Quick and easy installation in just minutes. Combine your data automatically in the background and benefit of better insights and greater revenues.
Access Data Integration
Access data can be integrated and synchronized
Learn on this page how the data integration of
How it works
In fact, you only need to do the 5 following steps to get your Access data integration started.
1: Set up your connection direction as required: one-way or two-way.
2: Set up your data source, in this case, Microsoft Access.
3: Set up your target, for example, a Microsoft SharePoint list or library.
4: Set up your mapping.
5: Run your connection!
Benefits of using Layer2 Cloud Connector for Data Integration
Access Connection Settings & Intro tutorials
You can find here the Connection Settings for
Connection Settings for the .Net Framework Data Provider for OleDb:
"How-to-connect" documentation of Access & SharePoint with .Net Framework Provider for OleDb:
Connection String Example
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Applications\QuoteWerks\Products.mdb;Persist Security Info=False;
Select
SELECT ID, Description, Availability, Cost, ManufacturerPartNumber, Category FROM Products;
Connect Access with the following systems