Import Text File Into A Spreadsheet with over 65,000 lines

  • Thread starter Thread starter Ecohouse
  • Start date Start date
E

Ecohouse

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Breakdown Excel 2007 worksheet to 65,000 worksheets for Excel 2003 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing Text Files Into Access 1
over 65,000 rows 5
Macro to split up Excel files that are larger then 65,000 rows Options 1
Import Text File into Spreadsheet 2
find sheet 3
Importing text files into same workbook. 2

Back
Top