Integrating Your Access Database with Other Systems
Automate the import and export of data by integrating your Access database with other systems
Eliminate time consuming and error prone re-keying by automating the import and export of information between your systems.
Upload and download information automatically with 3rd parties or web sites and services.
Integrate with MS Office applications to automate the generation of documents, spreadsheets, emails and appointments through diary and schedule management systems.
Speed up your business processes and gain competitive advantage by seamlessly transferring data from one system to another as it flows through your business.
Our experience of integrating Access databases with other systems
We have a wide range of experience in many sectors implementing Access database and SQL Server systems with existing business tools, including:
- Exporting customer and invoice information to SAGE Accounts systems
- Generating complex documents in MS Word
- Generating spreadsheets in Excel
- Importing/exporting tasks and appointment/calendar information with Outlook & Exchange
- Importing/exporting CSV files to a to/from many different systems
- Uploading/downloading data to websites
- Integrating with 3rd party data providers
- Integrating with MySQL, and various other non-Microsoft databases
- XML uploads and downloads
Examples of projects integrating Access databases with other systems
Event Management Company
For an event management company which users a web based system for registering interest in events and for booking places on the event and it’s associated seminars we developed an Microsoft Access database to be used by the office staff which at the click of the button automatically downloads all the latest registration data from the MySQL database on the website.
There is no need for users to run data exports on the website or to manually transfer files via FTP etc. Everything happens automatically and seamlessly. Once the data has been downloaded the system then performs various duplicate records checks and various other validations before updating the database with the new data.
Gas Service Engineers
For a gas servicing company which employs a team of engineers on the road servicing gas appliances we have developed an integration with their existing Access database which automatically uploads jobs via an XML feed to the engineers mobile devices so that they always have the latest job information and schedule to hand.
Once the job is completed the engineer enters the job details on the mobile device and obtains the customers signature after which the job is automatically transferred back to the database via a web service and XML feed.
Working with an educational charity who have a large number of local and regional organisers around the country we developed a system which automatically reads in the statistical spreadsheets submitted by these organisers and after appropriate validation and checking inserts the information into a management database which lets the charity track and report on the progress of its various activities.