Hi Saurabh, Please change the name of the file to "data.csv", or "data.txt" before importing. This is something I have already replied to you Sep 25, 2009. The crux here is to check the data file name for spaces. Thanks.
Best regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Fri, Sep 25, 2009 at 5:50 PM, Saurabh <saurabh.pa...@in.aegisglobal.com>wrote: > Hi Dilip, > > > > Thanks for the solution, just facing a small difficulty in importing a > file. Attached is the screenshot of the error. > > > > *Regards,* > > *Saurabh Patel* > > *+919824444814* > > > > *“The earth is enjoyed by heroes”—this is the unfailing truth. Be a hero. > Always say, “I have no fear.” - Swami Vivekanand*** > ------------------------------ > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Dilip Pandey > *Sent:* Sunday, September 20, 2009 10:58 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Re: Splitting a text file > > > > Hi Saurabh, > > > > Solution is attached herewith. Thanks > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > > On 9/18/09, *Saurabh* <saurabh.pa...@in.aegisglobal.com> wrote: > > Hi All, > > > > I am importing a text file into excel where there is more data than 65536 > rows. Can I have any macro, xla file or any addin to spilt the text file > into different sheets. > > > > *Regards,* > > *Saurabh Patel* > > *+919824444814* > > > > *“The earth is enjoyed by heroes”—this is the unfailing truth. Be a hero. > Always say, “I have no fear.” - Swami Vivekanand* > > > > > > > > > > DISCLAIMER:The information contained in this electronic message and in any > attachments to this message is > > confidential, legally privileged and intended only for the person > or entity to which this electronic > > message is addressed. If you are not the intended recipient, > please notify the system manager and > > you are hereby notified that any distribution, copying, review, > retransmission, dissemination or > > other use of this electronic transmission or the information > contained in it is strictly prohibited. > > Please accordingly also note that any views or opinions presented > in this email are solely those of > > the author and may not represent those of the Company or bind the > Company. This message has been > > scanned for viruses and dangerous content by Mail Scanner, and is > believed to be clean. > > The Company accepts no liability for any damage caused by any > virus transmitted by this email. > > > > > > > > > > > > > DISCLAIMER:The information contained in this electronic message and in any > attachments to this message is > confidential, legally privileged and intended only for the person > or entity to which this electronic > message is addressed. If you are not the intended recipient, > please notify the system manager and > you are hereby notified that any distribution, copying, review, > retransmission, dissemination or > other use of this electronic transmission or the information > contained in it is strictly prohibited. > Please accordingly also note that any views or opinions presented > in this email are solely those of > the author and may not represent those of the Company or bind the > Company. This message has been > scanned for viruses and dangerous content by Mail Scanner, and is > believed to be clean. > The Company accepts no liability for any damage caused by any > virus transmitted by this email. > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
