Importing Text File with more than 65536 rows

A

Allan

I am tring to import text files, into column A, but some files contain more
than 65536 rows. I would love to get the rest of the file in Column B if when
the file contains more than 65536 rows
 
A

Alok

Look at this link. Microsoft article explains how this can be done. You may
have to modify the code somewhat since you want the additional data to go
into column B rather than to the next sheet.

Alok Joshi
 

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

Split a text file with more than 65536 lines over many worksheets 5
Cell data entering slow! 0
Excel 2007 - ADO - More than 65536 rows - Problem ? 7
Excel --> Word 4
Reading in text file that is more than 65536 rows 2
Splitting data on sheets for more than 65536 rows... 1
Import Text file Data into Excel Sheet 3
import multiple files larger than 65536 2

Top