Help files

Connect to Excel or Access Database

Connect to an Excel Database:

To connect to an Excel database the most common connection string that one can use is:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myExcelFile.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";

Where Data Source is the full path of the Excel File.

Connect to an Access Database:

To connect to an Access Database the most common connection string id the following:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb; Persist Security Info=False;

Where Data Source is the full path of your Access Database

For other Databases like SQL Server, Oracle, My SQL please, have a look at the Connection strings section.