Append data from external database

  • Follow


I need to import data from a live table in one database to a table in another 
database. The data I am importing is not indexed. I would like to be able to 
import this data into my table that is indexed. My table is indenticle 
structure except for the indexes.
I only need to refresh my table intermittently, so I delete all the records 
from my table  and append all the records including the most current records 
from the live table  to my table. I am using a link to the live table. When I 
attempted the append I received an error "invalid argument." Is there a way 
to handle this without having to copy the table into my database and adding 
the indexes everytime? There is a lot of data in the table so it takes quite 
a while.
0
Reply Utf 6/21/2007 3:01:00 PM

0 Replies
411 Views

(page loaded in 0.091 seconds)

Similiar Articles:
















7/21/2012 4:51:47 AM


Reply: