> For the complete documentation index, see [llms.txt](https://help.holixa.com/holixa-erp-picker/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.holixa.com/holixa-erp-picker/common-information/application-configuration/examples-of-connections-to-data-sources/ms-excel.md).

# MS Excel

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

**Settings `ConnectionString`**

{% code overflow="wrap" %}

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

{% endcode %}

**Settings `ConnectionSelectCommand`**

```ini
ConnectionSelectCommand=SELECT * FROM [List1$]
```

**Sample data file to download**

{% file src="/files/bM6kDibZjLSVGAJy8QFa" %}