Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 175
  • Last Modified:

Access db and O365

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
hellblazeruk
Asked:
hellblazeruk
1 Solution
 
PatHartmanCommented:
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now