Solved

Access db and O365

Posted on 2015-02-22
1
171 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 37

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

Office 365 Advanced Training for Admins

Special Offer:  Buy 1 course, get 2nd free!  Buy the 'Managing Office 365 Identities & Requirements' course w/ Accelerated TestPrep, and automatically receive the 'Enabling Office 365 Services' course FREE!

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
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…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

737 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