Column headings: By default, it is assumed that the first row of your Excel data source contains columns headings that can be used as field names.
#Excel odbc manager driver#
Therefore, the best solution is to use the Jet Provider rather than the Excel ODBC driver.īecause the Excel ODBC driver always assumes that the first row contains field names, the first row must always contain either valid field names, or dummy entries that the developer is willing to disregard.Ģ. The HDR= setting is available and functional when you use the Microsoft Jet OLE DB Provider and its Excel ISAM driver. If the first row of data does not contain column headings or other entries, the effective result is that the first row of data "disappears." However, in fact, the driver disregards this setting and the first row of data is always treated as column headings. According to the driver documentation, the optional FirstRowHasNames connection setting can be used to change this default behavior by using 0 for False and 1 for True. When you use the Microsoft Excel Open Database Connectivity (ODBC) Driver to connect to an Excel worksheet as an ODBC data source, the driver assumes by default that the first row of worksheet data contains column headers (field names). Please take a look at the KB article on the issue:īUG: Excel ODBC Driver Disregards the FirstRowHasNames or Header Setting According to your question on ODBC connection with Excel to display the first row, I would like to provide you the related information and advice as follows:ġ.
0 kommentar(er)
