This is the problem I am having. I am attemoting to import a CSV file into a temporary table in MS Access. I have set-up an import SPEC that lists the columns the data must go into.
I have wirtten a module, that automatically calculates the file to be imported from a location on my PC. The module should locate the fiel then paste the data into the correct column according to the SPEC.
It is copying the data but is using the top row of the CSV file as the column headingS, and is therefore missing a row that contains AD REVENUE details. It is importing everyting else. It is doing this even though, when creating the SPEC I ahve told the app that the first row contains data, any ideas?
I have also created an ODBC link to the data held within the folder, so it knows what it is looking for.
I have wirtten a module, that automatically calculates the file to be imported from a location on my PC. The module should locate the fiel then paste the data into the correct column according to the SPEC.
It is copying the data but is using the top row of the CSV file as the column headingS, and is therefore missing a row that contains AD REVENUE details. It is importing everyting else. It is doing this even though, when creating the SPEC I ahve told the app that the first row contains data, any ideas?
I have also created an ODBC link to the data held within the folder, so it knows what it is looking for.