Last updated 1 year ago
An example setup, including a downloadable source data file, for an MS Access database is shown below.
Settings ConnectionString
ConnectionString
ConnectionString=Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Temp\Holixa ERP Picker Settings\accessData.accdb
Settings ConnectionSelectCommand
ConnectionSelectCommand
ConnectionSelectCommand=SELECT * FROM MATDBEN
Sample data file to download