Import CSV file runs out of columns

C

Chuckf201

I'm importing 300 fields into excel. I seem to hit a wall at 256. How can i
expand ??

If i can't expand how can I work around this. This is a tempory stage with
final destination into Access.
Thanks in advance

Chuck
 
C

Chip Pearson

Excel is limited to 256 columns; this cannot be increased. And,
if memory serves, Access is limited to 256 columns as well, so
you need to rethink your whole project.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message
news:[email protected]...
 
J

Jamie Collins

Chip Pearson said:
Access is limited to 256 columns as well
Click to expand...

If you are referring to a table in a Jet (MS Access) database, the
limit is 255 columns. In practice it is often less if a column has
been dropped or altered and the file has not subsequently been
compacted.

Jamie.

--
 
Top