I am trying to create a routine to import CSV files into an Access Database, but I want the process to account for all of the CSV standards listed at http://www.edoceo.com/utilis/csv-file-format.php
The problem is that the CSV files I'll be opening will have 42 fields. So, do I have to read all 42 individually, or is there an easier way? I'd like all of the fields accessible by variable so that I can then put them in the right place in the database (assuming this is the best way?).
Also, I'd like the process to simply skip a line if there is an error.
Thanks for any help!