Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
csv file with 268 columns necessary
Hello. I have a csv file that is generated from an agent in Lotus
Notes. It, obviously, produces a "file not loaded completely" error when attempting to open in Excel. Is there a way to extend the layout for certain files in Excel? All of these columns need to be included in the file. Thank you in advance for any assistance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
csv file with 268 columns necessary
You would need to import it in 2 stages, first 256 columns in one sheet and
then the rest in another You could open it in a text editor and split the file and put the last 12 columns in a separate file then import that file in a separate sheet. Note that Excel 2007 has 16384 columns -- Regards, Peo Sjoblom "MD" wrote in message ups.com... Hello. I have a csv file that is generated from an agent in Lotus Notes. It, obviously, produces a "file not loaded completely" error when attempting to open in Excel. Is there a way to extend the layout for certain files in Excel? All of these columns need to be included in the file. Thank you in advance for any assistance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
csv file with 268 columns necessary
Using Excel 2007 is one option.
Another option is to go into your csv, manually chop out the first 12 columns, save as a new file, then import the two files separately. -- David Biddulph "MD" wrote in message ups.com... Hello. I have a csv file that is generated from an agent in Lotus Notes. It, obviously, produces a "file not loaded completely" error when attempting to open in Excel. Is there a way to extend the layout for certain files in Excel? All of these columns need to be included in the file. Thank you in advance for any assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I HAVE AN EXCEL FILE 3 COLUMNS , WHICH I HAVE TO ADD ON THE THIRD | Excel Worksheet Functions | |||
All columns not being recognized in .csv file. | Excel Discussion (Misc queries) | |||
Displaying CSV file in columns? | Excel Discussion (Misc queries) | |||
Import .txt file format into two columns and not one row | Excel Discussion (Misc queries) | |||
.csv file Text to Columns | Excel Worksheet Functions |