View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary L Brown
 
Posts: n/a
Default Import more than one sheet into excel

Chuck,
I've put together a workbook that was designed to import more that 65,000
lines of text by splitting it into multiple worksheets. It will import the
data into worksheets of user-specified lines. For example: if you have
10,000 lines of data (or 300,000 lines), you can split the data into 2,000
lines per worksheet if you want.
If you'd like, I will email you the workbook.
--
Gary Brown
<== to respond, use ge.com


"Chuck" wrote:

I create a tab delimited file on and HP3000 and import it successfully
into Excel. What ascii or oct or hex character can I put in the file
so when I import it i can have multiple sheets in the excel file.