Transfering data from one database to another?

  • Thread starter Thread starter Pringle9984
  • Start date Start date
P

Pringle9984

I've been requested to write a program to transfer data from one M
Access database to another MS Access database (doing it manuall
isn't a problem but an automated program is required)

I have a query which converts the data in DB1 to the right format (
few fields are slightly different, etc), then to do it manually I'
literally just copy and paste the results of that query into th
appropriate table on DB2

I was wondering if there was an easy way to do something like

Run Select As Query (to correctly forma
data
Save Results (as a table or an external file
Run Insert Query on DB

Ideally as a single program to run on DB1 but if necessary I could ru
a program on DB1 to convert the data save it (as CSV or something
then run a program on DB2 to run an Insert query to insert all th
data

Any suggestions or a starting point would be greately appreciated
 
are the locations of the two databases always known?

Why not in the first db1 table design go

new->link table

Just link in the table from db2.

Then, in db1, take your query that you made, and change it to a append query
(while design mode for the query, go query->append query).

You can now drop in (map) the from fields to the "to" fields.

once you done the above one time thing, to append data, you simply click on
the append query and run it...
 
Back
Top