Append Excel Data To Access Table. I have over simplified this example but it does reflect something i am trying to do. Next you specify whether to append records to a table in the current database or to a table in a different database.
In the wizard dialog choose Append a copy of the records to the table and then select the importOrders table from the drop-down. The next dialog box displays the list of worksheets available to import. The following is the code that I have written to try to get this to work but.
After accumulating a lot of data there comes a time when it is nice to have everything in the same place.
I dont want to link I want to append. Hi all Im trying to find something similar to the TransferSpreadSheet command to import and append records to an existing Access table. Thanks Hi Dorris Ok so if you want to run this in an Access Database then below code will be sufficient. So I dont want to IMPORT from Access.
