How to export Access file to Excel automatically

1143015 pts.
Tags:
Microsoft Access
Microsoft Excel
Our department has a Microsoft Access database file that updates all of the time. We need to export all of this data to Microsoft Excel automatically. So whenever we need the newest updates, it happens automatically (not manual process). How can we do that? Would a Power Query work?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

You may be best off writing a script or .NET app and the scheduling it to run either with task manager or setting up an agent job to run on the server. Take into consideration how often you want to refresh the data. You don’t want to cause any performance issues.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: