Access Table Import with VBA

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
 
K

Ken Snell MVP

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Table Import with VBA 2
How to export table from outlook into ms access table? 0
Import Excel 2010 table into Access 2010 - not listed as range 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Import File Information 0
Import a dbf database into existing access table? 2
Refresh Imported Table with VBA 1
Import Errors table? 1

Top