Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
MD MD is offline
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I HAVE AN EXCEL FILE 3 COLUMNS , WHICH I HAVE TO ADD ON THE THIRD rosygucci Excel Worksheet Functions 4 April 26th 07 07:54 PM
All columns not being recognized in .csv file. Decision Assist Excel Discussion (Misc queries) 3 October 17th 06 07:59 PM
Displaying CSV file in columns? Terry Pinnell Excel Discussion (Misc queries) 2 October 8th 06 06:10 AM
Import .txt file format into two columns and not one row frdrsjr Excel Discussion (Misc queries) 1 January 9th 06 10:16 PM
.csv file Text to Columns Duane L Kibby Excel Worksheet Functions 1 April 29th 05 12:29 AM


All times are GMT +1. The time now is 07:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"