sql question
-
looking for an alternative and efficient way to transfer table records from one database to another database. could it be done with one sql? ty in advance maytel
-
looking for an alternative and efficient way to transfer table records from one database to another database. could it be done with one sql? ty in advance maytel
If the databases are in the same server, and the database user account has access to both, you can easily copy data from one database to another:
insert into database2..someTable (oneField, anotherField)
select oneField, anotherField
from database1..SomeTableDespite everything, the person most likely to be fooling you next is yourself.
-
If the databases are in the same server, and the database user account has access to both, you can easily copy data from one database to another:
insert into database2..someTable (oneField, anotherField)
select oneField, anotherField
from database1..SomeTableDespite everything, the person most likely to be fooling you next is yourself.
ty for the prompt help but could i ask for code sample? insert into C:\database2... select * from c:\database1... ty
-
ty for the prompt help but could i ask for code sample? insert into C:\database2... select * from c:\database1... ty
-
What type of database? It looks like you may be talking access here?
Bob Ashfield Consultants Ltd
sorry yup im using access
-
sorry yup im using access
maytel mynt wrote:
using access
So use File-->Get External Data-->Import to import the tables you want.
-------------------------------------------------------- Knowledge is knowing that the tomato is a fruit. Wisdom is not putting it in fruit salad!!