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..

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