How to write a query get all infomation from one table to another one

Question

I am building access database that will get data from a outside source and place it in a table that is link to the data source. As we all know that you are not allowed to recinfigure that linked table.

What I want to do is take that data from that that linked table and make another table that I will be able to add additional new fields and snyc the out that gets put into the linked table.

Please Help

Answer 1

You need to read up on append queries:

http://www.databasedev.co.uk/append_query.html

In other SQL systems, this would use some variant on "INSERT INTO" or "SELECT INTO"

Answer 2

The other alternative would be to use DoCmd.TransferDatabase to import the table. This can be done from any data source that Access can use via a linked table. It might be a little tricky figuring out the exact format for the connect string if it's not an Access table, though.