I am not a guru, hopefully I am a good programmer, but this article sure encourage me to keep on trying to work for good programming and a  satisfying execution of...

Because they are big does not mean they know what they are talking about, it just means they can sell it better, and have the means to buy the good...

Shanmugaraj,

If youre SQL servers are connected you can try to create a linked server and copy the databases with DTS.

Hope this helps,

Alex

How did you create your query in VB?

If you are using the Recordset.Open to execute a SELECT statement you will have to close the recordset yourself, but with the INTO...

Phil,

Thanks, I will try this option. Looks like a good solution.

I will come back if this is not a satified solution. (it can take a while before I can...

Shashank,

I do not use a query, I use the data import wizard. I assume that if I have to write a query, I would have to compare every row in...

Sushila,

I did try the append data option, but then the data that already have been copied in a previous action will be inserted again. Then I have duplicate rows.

The append...

Shashank,

Thanks for your reply, but I don't think it is the solution. (or I don't understand it correct).

I don't have a query in the DTS package, I use the copy...