Text File > 65535

[Josh Whitney]

I have a text file that is over 80,000 rows. If I import the first 65535 on
one page, and try to import starting at 65536 I get an 'invalid integer'
error.
What is the correct way to import a file with more than 65535 rows?

TIA

 

[Paul B]

Josh, have a look here and see if this will do
http://redirx.com/?gtya
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

 

[jeff]

Hi,

I believe you'll have to break up the text file before
importing - can you simply open it, estimate about 1/2
and cut the 2nd half out and paste into another file?

jeff

 

[Guest]

use Access