0

I have this OLEDB connection string
connectionstring as string = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ data.toString & ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=2

I just want to know what is the meaning of
HDR and IMEX, and what are their purpose on the connection string
Thanks..

1
Contributor
1
Reply
3
Views
5 Years
Discussion Span
Last Post by jbutardo
0

I have this OLEDB connection string
connectionstring as string = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ data.toString & ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=2

I just want to know what is the meaning of
HDR and IMEX, and what are their purpose on the connection string
Thanks..

HDR means Header, if it the HDR=Yes, it means that the first row will be the header, otherwise, the excel will create it's own header

IMEX means importexport - a function used for excel to import and export it's data

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.