Thread: Import Text File Into A Spreadsheet with over 65,000 lines
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Import Text File Into A Spreadsheet with over 65,000 lines
http://support.microsoft.com/kb/120596/en-us
Importing text files larger than 65536 rows

That should be a start.

--
Regards,
Tom Ogilvy



"Ecohouse" wrote in message
oups.com...
I need to have some VBA code to import a text file into an excel
spreadsheet. I know that a worksheet can't have more than 65,000
lines. So the overflow needs to go into another worksheet. And the
text file uses the ";" as the delimiter.

Any help would be appreciated.



Reply With QuoteReply With Quote