Does the table already exist in both databases (meaning, are you just trying to copy the data) or are you trying to copy both the data AND table schema?
If the table exists in both database and you are just trying to copy the data, you can accomplish this easily by creating one connection to databaseA, and a second connection to DatabaseB. Then create a dataset to each table and use the Merge method of the dataset object to "copy" the data. It works quite well.
Now, if you need to copy the table schema AND data, this gets a little tricky. Ket me know if this is what you are attempting and I will find something to do this (I remember seeing something like this somewhere...just need to find it again).
Scott
|