var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Code for appending data to an existing access table from excel
I need help on how to wite the code in access form to append data in an existing access table from a specific sheet of an excel file.
Let me add I am not a I.T. Professional , so please help by giving answer in detail i.e. code in detail.
Thanks and warm regards
Use the TransferSpreadsheet method of the DoCmd object, like this:
See online help or MS Access documentation for the meaning of the different parameters. Depending of the version of Access and Excel that are in use, some differences might exist in the parameters.
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel<x> , <Table name>, <File name>, True/False, <Range>
You could also use an ADO object to create a link to the Excel file but it's more complicated.
Have a nice day
Or perhaps could do File | Get External Data | Link Tables to link to the table in the Excel file. And then you could have code behind the form run an append query based on the Excel table that writes to the Access table.