Import CSV file runs out of columns

[Guest]

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

 

[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]...

 

[Guest]

Thanks - I need to reduce my field count.

Chuck

 

[Jamie Collins]

Access is limited to 256 columns as well

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.

--