Member Avatar for jbutardo

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
  • 1K Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by jbutardo
Member Avatar for jbutardo

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.