Automating the import function

M

Matt

Can someone provide the VB code to import an Excel file automatically?

I have tables containing data that will be deleted automatically by a Delete
Query and then I need an Import. The data will be imported from an Excel
file always using the same name and location.

Is there a Docmd.import ("Excel absolute path", "Existing Access Table")
code I can use?

Thanks,
Matt
 
Top