Executing an Update Query from a script file

[LaBelette]

Hi!

I need to execute an update query, but I have to do it while the database is closed, overnight.

Is there a way to do it with, for example, a VBSccript? I plan to use the Windows Scheduler to trigger the script.

Thanks a lot!

 

[Pat Hartman]

If VBScript can use ADO, you can update a table directly from the script file. If not, you can use the script to open a db and run a macro that runs the update.