Access 2003: Import Specification

[compooper]

Hi there,



Is there a way to save in your import specifications, delete the first ROW in a table?
The 2nd row in my data is the column headings, the first row in fact is just a fancy company header I do not need.

I am using Access 2003. Thanks

[Robeen]

Did you ever figure this out? Just curious.

I do a lot of Import/Export stuff that is automated but I have never had to deal with this problem.

What I HAVE had to do in a couple of instances is to let the data from unwanted row[s] come into my tables and then deal with them in the sql.

It's a little extra sql

[like an Is Not Null clause on a field that I KNOW will always have data in an actual data row but will always be empty in that row that has the unwanted data].

but it has got the job done for me.

[compooper]

Hi Robeen,
I ended up making the user manually delete the header and then import the file.

Then a whole lot vba code is used to manipulate the data.