Automate a Import Process/Maybe just a Refresh

[Dave Smith]

I’d like to try and automate a import process. Below are the steps I currently use to get these excel spread sheets into my ms access database.

Manual delete tables Table1, Table2, Table3, Table4.
Open the macro to TransferSpreadsheet exel TableA
Open the macro to TransferSpreadsheet exel TableB
Open the macro to TransferSpreadsheet exel TableC
Open the macro to TransferSpreadsheet exel TableD

“All these tables have the same type of data, and field names”

Run append query to Master_Append_qty for all 4 Tables.

Is there a way I can just do a refresh. All

Can I get some advice or help automating this process

Thanks for all your help and time
TCB

[Lysander]

You could put a button on your form, and use the On_click event to write VBA code something like this.

db.Execute ("DROP TABLE Table1;"), dbFailOnError
db.Execute ("DROP TABLE Table2;"), dbFailOnError
'etc for all tables
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel7, "Table1", "C:\Myspreadsheet1", True
 
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel7, "Table2", "C:\Myspreadsheet2", True
 
etc