Import and export data (1 Viewer)


Registered User
Nov 19, 2007
I have 2 access databases that I need to share data between. In DB1 I need to export data. I have created a query that will get me the data that I need to export. Is there a way to do this automatically like in SQL Server's DTS packages or can I create a button that will fire off the export process?

In DB2 I need to import that data. I have the same question as above, can I do it through an automated process or button click?

How do I do either of these tasks.


Pat Hartman

Super Moderator
Staff member
Feb 19, 2002
Rather than exporting/importing, why not have one db link to the tables in the other?


Registered User
Dec 6, 2006
Look up the help on this:


You can code this so it will export a spreadsheet of the data from DB1 - just use the query you made as the source. You can specify the file location where to put it or have the user choose by using a dialog box, but that is more involved. In DB2 you can just do the same code, but import from the same file. For the import, the field names need to be identical to the table if you are importing to a table - if not you will need to import the file into a temporary table, and use an append query to get your data to the right spot in DB2.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom