BUG: Disregards ?????? ????? ODBC Excel FirstRowHasNames ?? ????? ???

?????? ????????? ?????? ?????????
???? ???????: 288343 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

??? ??????? ?????? ????? Microsoft Excel ????? ????? ???????? ??????? (ODBC) ??????? ????? ??? Excel ????? ?????? ODBC? ????? ?????? ??????? ???? ??????? ???? ????? ?? ?????? ???? ????? ????? ??? ???? ??????? (????? ??????). ???? ??????? ????? ????? FirstRowHasNames ??????? ???????? ??? ????? ?????? ??????? ?? ????? ??? ?????? ????????? ???????? 0 ??? ? 1 True. ??? ???? ?? ??????? disregards ?????? ??????? ??? ??????? ?? ??? ????? ?????? ???? ????? ?? ???????? ??????? ?????. ??? ?? ????? ???? ????? ?? ???????? ??? ?????? ??????? ?? ????????? ?????? ? ???? ??????? ??????? ?? ???? ????? ?? ???????? "?????."

?????

?? ??? ????? ???? FirstRowHasNames ?? ??????? ??? (HDR) ??? ?????? ????? ODBC Excel.

????

HDR = ??????? ????? ???????? ??? ??????? Microsoft ???? Jet OLE DB ??????? Excel ISAM ?????? ??. ????? ???? ???? ?? ??????? ???? Jet ????? ?? ?????? ????? ODBC Excel.

??? ?????? ????? ODBC Excel ?????? ????? ?? ???? ????? ????? ??? ????? ?????? ? ????? ??? ?? ????? ???? ????? ????? ??? ????, ?? ??????? ????? ?????? ??? ???? ?? ?????.

?????

???? Microsoft ?? ??? ??? ?? ?????? Microsoft ??????? ?? ????? ??? ???????.

??????? ????

????? ????? ????? ??????

  1. ????? ???? Excel ???? ??? ????? ???? ??????? ?? ?????? ??? ???? ????? ??????? ?????? Visual Basic.
  2. ?? ?????? A1? ????? ??? ??????? ?? ?????? ????? ?????? ???????.
  3. ????? ????? Visual Basic ???? ?? ?? ?????? ???? ??? ?????? ?????? ActiveX (ADO).
  4. ???? ???????? ???????? ??????? ??????:
    Private Sub Form_Load()
      Dim cn As ADODB.Connection
      Dim rs As ADODB.Recordset
      Set cn = New ADODB.Connection
      With cn
        .Provider = "MSDASQL"
        .ConnectionString = "Driver={Microsoft Excel Driver (*.xls)};DBQ=" & App.Path & "\Book1.xls;FirstRowHasNames=0;"
        .Open
      End With
      Set rs = New ADODB.Recordset
      With rs
        Set .ActiveConnection = cn
        .Source = "[Sheet1$]"
        .Open
      End With
      Debug.Print rs.Fields(0).Value
      Debug.Print rs.Fields(0).Name
      rs.Close
      cn.Close
    End Sub
    					
????? ???? ????? ?????? ?????? ????? Excel ?????? ??? ????? ????????? "F1" ??? ?????? ?? ???????? ????? ????? ?????? ????? ????? ???? ??? ??????? ?? ?????? A1. ??? ???? ???? ??? ?? ???? Debug ?????? ???? ??????? ?? ?????? A2 ????? ???? ????? ????? spite ?? ?????? ?????? FirstRowHasNames ??? ???. ?????? ?? ?????? A1 "?????" ???? ??? ??? ??????.

???????

???? ???????: 288343 - ????? ??? ??????: 19/???/1424 - ??????: 3.2
????? ???
  • Microsoft Data Access Components 2.1
  • Microsoft Data Access Components 2.1 Service Pack 2
  • Microsoft Data Access Components 2.1 Service Pack 1
  • Microsoft Data Access Components 2.1 Service Pack 2
  • Microsoft Data Access Components 2.5 Service Pack 1
  • Microsoft Data Access Components 2.5
????? ??????: 
kbmt kbbug kbmdacnosweep kbpending KB288343 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????288343

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com