This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
I have Excel and Access 2013. I'm looking to export some Access queried tables (linked to some ODBC SQL data sources) to an Excel file, which I would later use to modify and generate some reports. The goal is to make the process as automatic as possible. So currently, I'm looking for a way to automate the export process. The built-in feature I found does this through outlook, and it seems to do nothing but provides a reminder to manually do the steps. Is there a way (maybe scheduled tasks or some scripts) that can help my purpose here? Also, I've tried to link Excel file directly to data source, but the process seemed rather inefficient.
Any input is appreciated, thanks
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Youy can use Task Scheduler (a Windows utility) to run a separate front end on a schedule. The front end would then have an autoexec macro to run your exports.