Hello -
Currently I am trying to automate a query from MS Access 2007. I tried messing with task scheduler but it continutes to give me issues. My thoughts were to link it in excel and then maybe write a macro to do the following...
1. open excel at a specific time
2. auto- import query results and save down the excel file with naming convention for the current date.
additionally my query needs to be updated in one field to show the date before the current date each day it is run... so if its run on 5/8/14 the field would have 5/7/14, and on 5/9/14 it should have 5/8/14 as a parameter.
the query is called "CORE Production Numbers" and is linked via the data tab -> "from access"
I've searched other forums for autorunning a query and saving it down as an excel file but it seems there are multiple ways to do this and it is a bit confusing to me - especially since I need the parameters to change on a daily basis...
is this at all possible or the best way to do it?
Currently I am trying to automate a query from MS Access 2007. I tried messing with task scheduler but it continutes to give me issues. My thoughts were to link it in excel and then maybe write a macro to do the following...
1. open excel at a specific time
2. auto- import query results and save down the excel file with naming convention for the current date.
additionally my query needs to be updated in one field to show the date before the current date each day it is run... so if its run on 5/8/14 the field would have 5/7/14, and on 5/9/14 it should have 5/8/14 as a parameter.
the query is called "CORE Production Numbers" and is linked via the data tab -> "from access"
I've searched other forums for autorunning a query and saving it down as an excel file but it seems there are multiple ways to do this and it is a bit confusing to me - especially since I need the parameters to change on a daily basis...
is this at all possible or the best way to do it?