Hi

I have an access database with a table called products with over 100000 products provided by 100 suppliers. Each product has a unique supplier id.I frequently need to update this table with new supplier catalogues. This information is contained in another database provided by each supplier which has an identical table structure as the products table. What is the most efficient way to import this data in to my original database using an sql query?

i am also having the same problem, i want to move some tables from one database to another database in sql server 2005. please help me if you find any solution.

Not sure if this is the BEST method, but if the table structures are identical you can use:

INSERT INTO database_name.owner.table_name
SELECT * FROM other_database_name.owner.table_name

You could also use a SELECT [column] INTO database_name.owner.table_name FROM other_database_name.owner.table_name

Again, the table structures have to match identically.

================================================== =========
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========