255+ Column CSV Import

[benatom]

An import routine which connects to a csv did not work properly. It
brought in data but it was not parsed or distributed correctly. I
discovered that the source csv now has more than 255 columns. If I
delete a few columns from the csv the import routine works fine
again. I am using an ADO connection to the csv. I only need data
from ten of the columns, but the csv, by virtue of being over 255
columns, has surpassed an Access limitation.

Any suggestions? Is there another way I can approach this?

Thanks.

 

[Douglas J. Steele]

One approach is to import the data line-by-line in VBA. Once you've read a
line in, you can use the Split function to break it into the individual
fields and then append a subset of those fields to your table.

 

[GeoffG]

The ADH has a TextFile class that'd open the file and read it
line-by-line (or you could program the same yourself). You could
then use the Split() function to parse out the columns you need
and use DAO to dump the data into a table. I don't know if
that'd be easier than chopping off the columns you don't need
before doing the import.

Geoff