How to write data from one database to another

[me1411]

Hello
I have two databases.
I want to take data from a table of the 1-st database
and
write them to a table of the second database.
Thank you.

 

[alvechurchdata]

If you can link the second table into the first database then a simple update query will do the job.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[TheAceMan1]

How are ya me1411 . . .

This can also be done with an [blue]action query[/blue]. Note, in the SQL:
[ol][li] [purple]tblDes[/purple] is the destination table name of the current db where the query is run.[/li]
[li][purple]tblSrc[/purple] is the source table name from the source db.[/li][/ol]

[blue]INSERT INTO tblDes ( desFieldName1, desFieldName2, ... desFieldNameN ) 
SELECT tblSrc.srcFieldName1, srcFieldName2 ... srcFieldNameN 
FROM tblSrc [purple][b]IN 'Path and FileName to Src mdb'[/b][/purple];[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]