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
|