MS Excel

An example setup, including a source file with downloadable data, for MS Excel files is shown below.

Settings ConnectionString

ConnectionString=Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Temp\Holixa ERP Picker Settings\xlsData.xlsx;Extended Properties="Excel 12.0;HDR=YES" 

Settings ConnectionSelectCommand

ConnectionSelectCommand=SELECT * FROM [List1$]

Sample data file to download

xlsData.xlsx

11KB

Open