pjcltd
Posts: 34
|
Posted: 08/02/2012, 3:20 PM |
|
Hi
i have 2 connections to 2 differant database's
connection 1 go's to a MS SQL server 2008
connection 2 go's to a MS Access Database
what i need to do is copy the records for a table from connection 2 into a table on connection 1
i need to be able to do this in code.
Both of the tables are the same format
SELECT SERVER, RID, BACKUP_ID_STATUS, POLICY, SCHEDULE, MEDIA_SERVER, MEDIA_ID_DESCRIPTION, copy_no, [TIME], [DATE], PRI_copy
FROM Data
thanks for the help in advance
thanks
Paul
|
|
|
|