importing csv with specs

[datacontrol]

I have a process to automate. I need to import a csv file and delete the first row when doing so.

I suppose I could import as is, then query out the first row, however my column headings appear in the second row. So they will be missed if I import it in this fashion. Is there a programmatic way to do this? OLE?

Thanks in advance!

 

[st3ve]

Bit of a fudge but gets there

I don't know a smart solution to this, but you could do the following (much as you were suggesting):

Importing into access, set 'first row contains field names' to TRUE.

Then delete the first row in the table,save and export with the setting 'include field names in first row' to FALSE.

Finally, re-import this file with 'first row contains field names' set to TRUE.

You now should have the second row from the original table as the field names in your access table.

HTH