Is there a way to automatically skip row 1 of a CSV file when importing? Row 1 contains a header with filename, date created, period covered, total record count, etc., and then Row 2 contains the column names.
Unfortunately, that does not do it... as I explained, the 1st row does not contain the field names... they are in the 2nd row. The 1st row contains header information (filename, date created, period covered, total record count, etc.).
I need a way to eliminate the 1st row completely or for Access to ignore the 1st row and use the field names from the 2nd row.
I was looking for an automated way of doing that, so the user can simply receive the source csv file, and import it into the database without manual manipulation.
The alternative is to go back to the source and have them remove the header, but that comes at a $ cost, which I was trying to avoid.