Running MS Access queries from SQL Agent

[sjohnson1984]

Hello,

My question is pretty much summed up in the title of this: How do we run queries using SQL Server Agent.

Part of my company uses an Access dB, in this Access dB I have an append query that appends data to a SQL Server table: we want to have this query run overnight rather than, a prevelant case seemingly, having to have someone "push the button" every day. Obviously the append query is set to NoCount.

J

[ck9663]

I have not tried accessing Access and SQL-Server database in one apps. Here are a couple of options:

1. From SQL Server, create a stored proc that will read your Access DB and do the insert to your table. Test that stored proc. Once satisfied, run it as a scheduled/job process from SQL Server.

2. Try creating it in Access and try making it a scheduled/job from Windows scheduler.

-- CK