I will recommend you use a DTS will dynamic Querry option. That will be fast than cursor

Thanks

Why don,t you link the tables in the access and the SQL database. Ensure the security on the SQL server. Create a DSN with that security and select a 10...

I hope you are refering to the usage of these commands with variables.

The SET command is generally used when you have a know fixed value that you want to assign...

You can eliminate the drop table statement by chosing the formatting tab and removing the top two check boxes.

For dropping the indexes you will again have to use the sql...

This kind of error is generally encountered when the DTS has been develped on some other Server and then Copied to the new server.

The properties of the associated databases referencing...

What ever the comments are posted in this forum by my friends are valid.

I will just like to add one more. When you have configured your database to grow...