Access Table Import with VBA

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

I am trying to figure out the VBA code to import a table from one Access
database into a second Access database. Currently both the source and the
target table names are the same. I plan to run a query to delete all the
rows in the target table. I then would like to import the source table and
update the target table with the rows from the source table. I would really
appreciate a simple example.

Thanks,

Brad
 
Check out TransferDatabase in VBA Help. It is how you import or link to a
table in another ACCESS database.
 
Back
Top