Importing data from a CSV file

[robgriff]

I'm importing data from several .csv files into my MS Access V97 application through modules. The trouble is that some of the .csv files have header rows and some do not. When connecting to the .csv file, is there a way of declaring whether the file has a header row or not? I've been able to edit the registry to change this setting but I'd like to able to do it using VBA.

Thankyou

 

[Pat Hartman]

If you can identify the different formats ahead of time, you can import the files once so you can make and store an import spec. Once that is done, you can reference the import spec in the TransferText Method/Action. Note, you do not need a separate import spec for each file name. If you import multiple files with the same format, you can re-use the import spec.