ADO ConnectionString Excel
This page is still a work in progress.
Arguments
The Provider supports the following arguments:
- Data Source=
- Path & Filename of the Excel workbook you want to process
- Extended Properties="x"
- "x" stands for one or multiple of the following extended properties separated by a semicolon:
- Excel 12.0 Xml
- Specifies the type of Excel file to process
- HDR=
- Specifying HDR=YES means that the test file contains a header row. A header row simply means that the first row in the text file is a list of fields, with all subsequent rows containing the actual data.
- IMEX=
- Value 1 tells the driver to always read "intermixed" (numbers, dates, strings etc) data columns as text. Note that this option might affect excel sheet write access negative.