Hello
Is this above possible?
I need to take data from Microsoft Access and serve it up through Excel as a particular tool we use will only read from Excel. What I need is the Access file to export the data into the same Excel file say once-twice a week if possible.
My theory was save the export action in Access and then somehow use Windows task scheduler to perform the action when I want it to. However, I don't know if it will work. Maybe I'll need a macro in between?
Thanks for any help
Is this above possible?
I need to take data from Microsoft Access and serve it up through Excel as a particular tool we use will only read from Excel. What I need is the Access file to export the data into the same Excel file say once-twice a week if possible.
My theory was save the export action in Access and then somehow use Windows task scheduler to perform the action when I want it to. However, I don't know if it will work. Maybe I'll need a macro in between?
Thanks for any help