View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David Coleman[_3_] David Coleman[_3_] is offline
external usenet poster
 
Posts: 7
Default "file not loaded completely" error

Hi Joe

I don't believe that the 256 column limit can be increased. However, you
could try:

transposing the data (ie turn rows into columns and vice versa) - this
depends on how many rows of information you have as it would be limited to
256...

or

splitting the data across multiple sheets - sheet1 has the first 256
columns, sheet2 the next 256 and so on

Regards

David



"joe" wrote in message
...
I exported a large database file to a comma delimited file
(csv). When I try to open the .csv file in Excel, I get
the above error message. The database file contains more
than 256 fields (max columns in Excel). Is there a way to
expand or change that number.

Appreciate any help.

Thanks