Recent content by dchen

The query syntax in MS Access is a bit different than MS SQL. I found out that another way is to build a batch program to run the sqlcmd and put it into the Windows Scheduler. Would this way be better? Then the MS Access doesn't have to be always running in the background.

I know Access can setup an Outlook Task to auto-export query to Excel, but it requires the Outlook to be always open on the user's computer. Is there an easy way to setup a schedule that can automatically export a query to Excel and this schedule will then auto-email the exported Excel file to...