Text File > 65535

J

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
 
P

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 **
 
J

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
 
Top