Can anyone help me in VBA codes in MS access how to export at the same time append it to existing MS access table. My excel file and access table have the same data content so its seems like it will be export-copy-paste append to access table.
What I have is 2 Ms Access mdb file (mdb1 and mdb2)
mdb1 - contains table with data
mdb2 - contains forms with code to select excel file and append its data to the mdb1 table.
I need some codes to put in my mdb2 forms to make this things work.