How to Import Data Without Headers 1

[silknowles]

I have been using Excel to open up my semi-colon demlimited data file, adding headers, and saving in Excel format to prepare a file to import into Access. Is there an easier way? I have 3 data files to import each week.

 

[mcatet]

Import the data using Access. (Get External Data).

The Wizard has an option to let it know that the first row in the delimited data has field names. Check this and that record will not be imported.

 

[DrSimon]

Use the Import Text Wizard and use the Advanced button to save the Import Specifications for each file type. You can then use the saved specs each week via the wizard or automate using the TransferText Method which has Import Specification as one of the arguments.

 

[silknowles]

Smack my hand to my forehead! I never noticed the Advanced button before. What a terrific solution. I have set up the import specification to mirror the table design, complete with indexes. Now my only problem is that my delimited file ends with ".dat" and not one of the acceptable extentions (.csv, .txt, .tab. or .asc). Until I come up with something better, I will have my user rename the extension when they bring over the file from the Unix box.

My sincere thanks,
S-

 

[hniessen]

When you come up with something better please let us (read: me) know. I have a comparable problem with a file that has the extention .exf.

Ofcourse I let you know when I come up with a solution myself.

Greatings,
Hans

"there is never time to do it right but there is always to do it over"