Import multiple sheet spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi
AFAIK Excel does not support this kind of operation. You'll have to
write your own code to achieve this
 
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.
 
You must log in or register to reply here.

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

Excel 2003 inserts quotes when saving SS as text and comma is pres 1
Paste comma delimited text into a spread sheet 5
Multiple Delimiters 5
Import Delimited File 1
Alt codes 4
Import more than one sheet into excel 2
*.csv format change if .xlt save as .csv in Excel 2007 1
Importing text with text qualifier 2

Back
Top