Importing large tab file to Excel 97

  • Thread starter Thread starter kbaker123
  • Start date Start date
K

kbaker123

I have a large tab file on CD that I'm trying to import/convert to Exce
97. The file has over 118,000 lines of data, however the Excel 97 ha
only room to convert the 1st 65,508 lines. It does a great job wit
converting into columns and lines, however I'm not getting the complet
file.

Any suggestions?
:eek
 
Excel only has 65536 rows. You will need to break your file into two parts
and import each separately. You have an option to set the start line, but
the limit is around 32,000, so that would not get you the whole file either.

Try opening it in word and split it by copying half your data to another
file (and deleting from the original data). Work on a copy of your data.

You could also write a macro to split it (or process it).
 
Thanks Tom!

I opened up the tab file in Word, broke it into a couple of files an
then saved as text file. I opened each file with Excel and i
converted flawlessly.

Thanks a bunch!

Coach B:cool
 
Back
Top