Solved

Access db and O365

Posted on 2015-02-22
1
167 Views
Last Modified: 2016-02-11
Hi,

I have an access db to I use to collate sales data from a POS system, currently I need to manually run the script below to import the sales figures from a csv file, I would like to add the database to our SharePoint so the reports are available on a dashboard, is it possible to make the script run automatically in O365 ?

Regards,
script.txt
0
Comment
Question by:hellblazeruk
1 Comment
 
LVL 35

Accepted Solution

by:
PatHartman earned 500 total points
ID: 40625055
Access web apps do not support VBA.  You should check but I don't believe that a web app can interact with Word or Excel.

To run this automatically, you can create a macro that runs the code and then closes the database.  It is important to remember to close the database.  Then using Windows task scheduler, you can schedule the application, using the x/ option to execute a specific macro to run daily (or more frequently).  If you have trouble getting Access to run this way, you can create a .bat file and schedule running the .bat file and that can open the Access app.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question