Automating the import function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
docmd.transferspreadsheet

Check the help file for the parameters.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import data from Access to Excel containing VB code 3
Importing Excel file without server access 3
Error while import Excel file to Access 6
Excel Import External Data by Date Automatically 0
Importing into existing table 5
Import table 5
Data Import Problem With Acess 2007 2
Importing from Excel 4

Back
Top