Import multiple sheet spreadsheet

M

Mike Johnson

I am importing a comma delimited text file into Excel 2002 SP3. The final
spreadsheet will encompass multiple sheets. What is the delimiter to tell
Excel to move on to the next sheet?

Thanks for any help.
 
F

Frank Kabel

Hi
AFAIK Excel does not support this kind of operation. You'll have to
write your own code to achieve this
 
D

Dave Peterson

Another option is to use your favorite text editor and split the text file into
smaller bits (less than 65k lines) and import each bit to a separate worksheet.
 
Top