VBA to Copy and Paste Append from Excel to Access

[fretcruiser]

So I have an Access file that I need to update daily. Right now my current process is to open the new Excel files every day and manually Copy and Paste Append the data into the Access tables. There are 4 tables all together that I need to do this with.

If need be I can save the excel files to have the same name in the same directory on a daily basis.

Is there a way I can automate this with VBA?

 

[alansidman]

Here is a tutorial: Tutorial for Microsoft Access Visual Basic: Read From and Write To XLS Files (Part 1)

 

[Micron]

Probably many ways to skin this cat. If you can overwrite the Excel filed everyday with the same name, why not just link to them and use them as tables for running queries against? Or TransferSpreadsheet function...