Automatically Adding New Data to Tables

[aquarius]

Hello Everyone,



I have a program that updates excel on a daily basis. This excel spreadsheet populates new data daily. How can I have access add the new data to existing tables automatically? Any insight or direction would be greatly appreciated.

[ajetrumpet]

I'm not really sure if VBA will let you append data in batches that are transferred in from Excel. You can always write them manually in basic, but that's too time consuming. I know you can import specified ranges from an xl sheet to a specified table in Access using transferspreadsheet, but I don't know if appending to the end of a set is possible. Is it with the import wizard so I assume it is with VBA somehow as well.

If it's not though, a workaround could be to use transferspreadsheet to import the new set into a temp holding table that's kept in access, and then simply run a one line append query after that to transfer the data to where you want it.