Export Access table to another Access Database

  • Thread starter Thread starter Tamer
  • Start date Start date
T

Tamer

Hi all,
I have an Access table in a database, I want to export
that table to another Access database programmatically.

The way I want the table to be exported is the following:
In the Close Event of a form, I want to export the table
to the other database, but I want it to overwrite the old
table. What is the code to do that? Please help
 
in the form's Close event, create an event procedure using the ellipsis
(...) button. in the procedure, type the following code

DoCmd.TransferDatabase

then press your left arrow key a couple times to backspace into the
TransferDatabase text, and press F1. the Help topic will tell you should
know about exporting a table, including your "overwrite" issue. this is one
piece of code it's a good idea to have a clear understanding of, before you
use it.

hth
 
Back
Top