Import data

[dealwi8me]

Can i import just the data of a database(not the whole tables) to another database? (Both databases have the same tables, fields and relationships)

I want to merge 2 databases is it possible? The databases have a lot of tables and relationships it's not simply a table.

Thank you

 

[ghudson]

Create a query to select the data you want and then export that query to a format that you can import into the other db.

If the tables have the exact fields and datatypes then you could simply open the table, select all records, click the copy button and then paste the selection into the other table in the other db.