how do I import a comma-delineated file with over 255 columns?

J

Joe Fallon

In code.
The wizard can't do it.

You read each line of the file, parse it and then add it to the correct
table in the Access Db using recordsets.
Note you can't put all the data in a single table as there is a limit of
255 fields per table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top