Integration with Other Systems - The Access Man

Integration 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 to automate the generate of documents, spreadsheets, emails and appointments.

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 Microsoft Access and MS SQL Server with other systems includes:

a) exporting customer and invoice information to SAGE Accounts systems

b) generating complex documents in MS Word

c) generating spreadsheets in Excel

d) importing/exporting tasks and appointment/calendar information with Outlook & Exchange

e) importing/exporting CSV files to a to/from many different systems

f) uploading/downloading data to web sites

g) integrating with 3rd party data providers

h) integrating with MySQL, and various other non-Microsoft databases

i) XML uploads and downloads

Examples of recent projects:

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 web site 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.

Educational Charity

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.

Our Reviews