Thread: importing more than 65536 rows from .csv file
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tony James[_2_] Tony James[_2_] is offline
external usenet poster
  
Posts: 15
Default importing more than 65536 rows from .csv file
On 23 Jan, 00:15, Vamsi Challa <Vamsi
wrote:
Hi

I am trying import a .csvfilewhich contains more than 65536 rows. I
created a macro to import and it is successfully importing with out a text
qualitfier. can any one help me how to import huge .CSVfiles to one excel
sheet?

If you are importing many records, using ADO and CopyFromRecordset
will be far quicker than using Line Input# and Split.
Could you give a sample of the first few lines of the csv file?


Reply With QuoteReply With Quote