By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,631 Members | 1,144 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,631 IT Pros & Developers. It's quick & easy.

Transfer table records from one to another

P: n/a
I have read many of the topics on importing tables from one database to
another. However, I don't want to use the TransferDatabase command
because I want to copy all the records (not the object) from one table
in an external database into my current database. My current database
already has the table and I want that table to keep its records.

Any ideas?

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
One approach is to use the IN statement. For example

INSERT INTO MyLocalTable
SELECT *
FROM MyRemoteTable
IN 'C:\MyRemoteDatabase.mdb'

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"pwh777" <pw****@hotmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
I have read many of the topics on importing tables from one database to
another. However, I don't want to use the TransferDatabase command
because I want to copy all the records (not the object) from one table
in an external database into my current database. My current database
already has the table and I want that table to keep its records.

Any ideas?
Nov 13 '05 #2

P: n/a
pwh777 wrote:
I have read many of the topics on importing tables from one database to
another. However, I don't want to use the TransferDatabase command
because I want to copy all the records (not the object) from one table
in an external database into my current database. My current database
already has the table and I want that table to keep its records.


Do the TransferDatabase anyway, but name the external table differently.
Then, use an Append query to copy your records. You can delete the
linked table afterwards.

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html

Nov 13 '05 #3

P: n/a
It's working. Thanks so much David! That was awesome.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.