Solved

Access db and O365

Posted on 2015-02-22
1
166 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 34

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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

910 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now