"file not loaded completely" error

  • Thread starter Thread starter joe
  • Start date Start date
J

joe

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
 
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
 
Back
Top