jeremysoh
03-10-2009, 01:01 AM
Hi, i have 2 same tables but on different database.. I would like to import the table data to an existing table THROUGH a button on a form.. is anywone who can do it??
|
View Full Version : Import table data via vba or macro.. jeremysoh 03-10-2009, 01:01 AM Hi, i have 2 same tables but on different database.. I would like to import the table data to an existing table THROUGH a button on a form.. is anywone who can do it?? Mike375 03-10-2009, 01:24 AM Did you try TransferDatabase action in a macro? That will allow you to name the table being imported and then run an append query and then delete the table that was imported (DeleteObject)....so it is ready to run again. |