How to append data from another database?

[longmatch]

I have a database requiring to append data from another database. The fields from the table of another database will be appended to several tables in the current database. Anybody knows how to do it? I am looking forward to getting your help.

Thank you

Haijun

 

[RottPaws]

Probably the easiest way would be to link the table(s) from the other database and then create a series of append queries to add the records to the tables in the current database.

Once you have them all done and working the way you want, you could set them up in code or a macro to run them all with one click. _________
Rott Paws

 

[longmatch]

If the field names are different from those I need append records to. How can I do it? Do you have any examples I can refer to?

Thank you

Haijun

 

[THoey]

If you do as Rott said, link the tables, you can write an append query, and it won't matter what the field names are:

INSERT INTO MyTable (FLD1, FLD2, FLD3)
SELECT FLDA, FLDB, FLDC
FROM SomeOtherTable; Terry M. Hoey

 

[longmatch]

Thank you for your help. I understand how to do it right now.

Haijun