View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default Excel Help Please

You can:

1 - find a copy of Excel 2007 that offers 16 thousand columns and over 1
million rows
2 - write VBA code to read each line of the file and place the first 256
columns into the first worksheet, the next 256 into the 2d sheet, etc.
3 - You can import into MS Access that (may) allow for lots more than 256
columns


" wrote:

Help me please

I am attempting to import a file that is too large for excel. It has
to may columns and is getting cut off. Is there anyway to import the
full spreadsheet?

I need to have rows and columns soo notepad is not an option.

Thanks
Rob