dominicdunmow
Technical User
I currently run some code that automatically imports a specific excel worksheet to an Access Table - using the "DoCmd.TransferSpreadsheet"
I want to import the same worksheet daily so I can capture any updates, but each time the code imports it, Access tries to append the new data to the existing table. My aim is to overwrite the existing table replacing it with the new table derived from the updated worksheet.
Can anyone tell me the code required to do this please?
Thanks