Importing Data from One Table to Another

[ncook]

I have created a test database.
Then someone sent me a similar database that was almost fully developed. I want to import the data that i had in the test database into a table in the newly developed table.

I do not have a clue how to do this. Can someone help me please?

Thanks

 

[namliam]

File => Get external data => Import

Regards

 

[ncook]

I do not want to import the whole table into the new database i need only the data to go into a table that has been created.

I have a table called tblTestAsset which has data in it.
I want only the data from this table to be imported into the new database into a table called tblDevices, this has all the same fields as the test table and even more and the whole database has been developed to a higher level than the test one.

I hope this makes sense!

 

[Rich]

Either copy them to the clipboard and use paste append or import the table and use an append query

 

[ncook]

That worked. thankyou.