Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update Query from Excel VBA module
I need to run a query against a SQL DB in Excel so I can use Task Scheduler
and run the Excel File every 6 hours. I created the update query in Access. SQL Server Name: SQL Database: Production Table: Job Heres the SQL query from Access: UPDATE Job SET Job.Priority = 0 WHERE (((Job.Job) Like "F*") AND ((Job.Status)="Active") AND ((Job.Priority)0) AND ((Job.Sched_Start) Is Not Null)); |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running a SQL Update Query in Excel VBA | Excel Programming | |||
How do I update a ODBC query in Excel using pivotTables in VBA? | Excel Programming | |||
Query a Access database that has a module from Excel | Excel Discussion (Misc queries) | |||
How To Query and Update Excel Data Using ADO From ASP | Excel Programming | |||
How access/query/update Excel using VC? | Excel Programming |