????? ??????? ADOX ?? ?????? Excel ?? Visual Basic ?? VBA

?????? ????????? ?????? ?????????
???? ???????: 303814 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

?????? ?????? ?????? ActiveX ???? ????? ???????? ? ?????? (ADOX) ???? ???????? ?????? ?????? ActiveX (ADO) ??????? ???????? ?? ?????? ?????? ??? ???????? (DAO) ??????? ?? ????? ???????? "?" ????? "?" ???? "?" ?????? ????? ?????? ???? ???????. ??? ????? ???? Microsoft OLE DB ????? Jet 4. 0? ???? ???? ????? ????? ISAM ?????? ????? Jet ?? ????? ?????? ??? ?????? ???? ??? Microsoft Access? ?? ?????? ??? ??????? ?? ?? ADO ? ADOX ?? ?????? Microsoft Excel ?? ????? ????? ?? ????? ADO.

??? ???? ??? ???? ??? Excel ??? ????? ?????? ????? ? ADO ???? ??? ?????? ??? ???????? ?? Excel. ?? ???? ?????? ?? ?????? ADOX ??? ?? ???? ?? ???? ????? ??? ?????? ??? ????????? ?? Excel. ????????? ??? ??????? ?????? ?? ???? ADOX ? Excel. ?????? ??? ??????? ?????? ??? ????????? ADO ?? Excel ? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
257819????? ??????? ADO ?? ?????? Excel ?? Visual Basic ?? VBA
??? ????? ??? ??????? ??? ??????? ???????:

??????: ?????? ?? ?? ?????? ??? ??????? ?? Microsoft Windows 2000 Server Service Pack 2 (SP2) ?? Microsoft Data Access Components (MDAC) 2.6 SP1 ? Microsoft Visual Basic 6 ???? ?????? SP5 Microsoft Excel 2002 (XP). ?? ?? ???? ??? ??????? ?? ?????? ?????????? ?? ?????? ???? ?? ?????? ?????????? ?? ????????? ???????? ?? Windows ?? MDAC Visual Basic ?? Excel.

??????? ????

???????? ADOX

?? ???? ???? ADOX ???? ?????? ?????? ????? ???????? ?? ?? ???? ???? Excel.
  • ????? ??????? ????? ????? ?? ???? ????? ADO ?????? ?? ??? ???? ??????. ???? ????? ????????? ???????? ?????? ????? ??? Book1.xls ??? ADOX ??????:
    Dim cat As ADOX.Catalog
    Set cat = New ADOX.Catalog
    cat.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=" & App.Path & "\book1.xls;Extended Properties=Excel 8.0"
    					
  • ????? ????? ????? ???? ?????? ???? ?? ????? ????? ???.

????? ??????

?? ????? ??????? ??????? ????? ???? ADOX ?????? ?????? ???? Excel ????. ??? ????? ?????? ???? ????? ????? ????? ???????:
??????? ??? ?????? ???? ?????? ???.
??? ???? ????? ????? ???? Excel ???? ?? ???? ????? ??? ??? ???? ???? ????? ?? ?????? ????? ???? ???? ??? ????? ??? ?????? ???? ???????? ???????? ??????? ?????. ???? ??? ??????? ???? ???? ?? ????? ????? ???? ??????? ??????? ADOX ???; ????? ???? ?? ???? ????? ????? ????????? ?? ????? ????? ????? ???? Excel ???? ???? ???? ?????? ?????? Excel.

????? ADOX

???? ADOX ???? ????? ?? ?? ???????? Excel (??? ???? ??? ?? ????) ???? ???? ?? ???? ?????? ????????.

????? ????

????? ??????? ADOX ?????? ????? ????? ?? Excel. ???? ?? ????? ????? ???? ???? ????? ????? ????? ? ???? ????? ????????? ???????? ?? ?????? "ADOX Columns".
  • ????? ???? ADOX ???? ????? ?? ???? ??? ????? ? ???? ???? ???? ??? ???? ????? ?? ????? ??????. ???? ???? ???? ???? ?????? ???????. ??? ???? ??????? ??? ??? ?????? ???? (????) ???? ?????? ??? ?????? ???? ???? ?????? ???? ??????! $ A $ 1: $ B $ 1, ??? ????? ?????.
  • ????? ????? ??? ???? ????? ?????; ??? ???? ?????? ADOX ??????? ?????? ???? ????? (_) ?? ???? ??? ???? ???? ???? ???? ????????.
  • ??? ????? ???? ??? ????? ???? ?????? ??????? ?? ?????? ??????? ????? ????????? ????? ??????? ??????? ?? ?????? Excel ?? ???? ????.
  • ??? ????? ????? ???? ???? ????? ???? ?????? ??????? ?? Excel ????? ????? ????? ???????:
    ??? ??? ????.
  • ??? ????? ????? ???? ????? ??? ?? ????? ????? ????? ????? ??? ?? ?????? ??? ????? ?? ???.
  • ??? ?????? ????? ??? ???? ????? ????? ????? ????? ???????:
    ??????? ??? ?????? ???? ?????? ???.

??? ????

?? ???? ??????? ADOX ???? ???? (????) ?? ???? ?? Excel? ???? ADOX ??????? ?? ??.
  • ??? ????? ??? ???? ????? (?????? $) ???? ????? ???? ??? ???? ???? ???? ????? ?? ??????. ???? ??????? ??????? "???" ???? ????? ???? ??? ???? ?? ???? ?? ?? ?????.
  • ??? ????? ??? ?????? (??????) ???? ????? ???? ??? ???? ???? ?????? ?? ??????. ??? ???? ??? ????? ??? ?????? ??? ????? ???? ????? ????? 3265:
    ?? ???? ?????? ??? ?????? ?? ???????? ??????? ????? ??????? ?? ??????.
  • ??? ????? ??? ???? ???? ?? ????? ????? ???? ???? ????? ???? ??? ??? ??? ?????? ?? ??????.

????? ADOX

????? ADOX ?????? ?? ??????? ?? ?????? ?? ????? ?????? ?????? ????? ??? ??????? ?? ???? ??? Excel.

????? ?????? ADO ????????? ?????? Excel

????? ADO ??? ????? ???????? ?? ???? ?????? Excel "???? ????? ????????? ?????? ?????:

  • adDouble ? ???? 5
  • adDate ? ???? 7
  • adCurrency ? ???? 6
  • adBoolean ? ???? 11
  • adVarWChar ? ???? 202
  • adLongVarWChar ("???????") ? ???? 203

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

  • ????? ????? ????? ?????? ??? ???? ??????? ?????? ????? ?? ????? ?????? ??? ??? ???? ?? ????????.
  • ????? ????? ????? ??????? ???? ????? ??????.
  • ???? ADOX ????? ???? ??????? ???? ???? ?????? ?? ????? ?????? ????? (') ? ??? ???? ??????? 'F1?' ????1 ? ' ????2. ??? ????? ?? ???? ??? ?? ???? ???? ????? ???? ??? ??????? ????? ???? ????? ??????.

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

????? ????? ???? ???? ???? ??? ?????? ?? ??? ????? ???? ??? ????? ???? ???? ???????? ADOX.

???? ???????? ???????? ?????? ??? ????? ???? ???? (????) ???? ????? ??? ?????? (??????? ???? ????? ????):
    Dim cat As ADOX.Catalog
    Dim tbl As ADOX.Table
    Dim col As ADOX.Column
    Set cat = New ADOX.Catalog
    cat.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
	"Data Source=" & App.Path & "\book1.xls;Extended Properties=Excel 8.0"
    Set tbl = New ADOX.Table
    tbl.Name = "TestTable"
    Set col = New ADOX.Column
    With col
        .Name = "Col1"
        .Type = adDouble
    End With
    tbl.Columns.Append col
    Set col = Nothing
    Set col = New ADOX.Column
    With col
        .Name = "Col2"
        .Type = adVarWChar
    End With
    tbl.Columns.Append col
    cat.Tables.Append tbl
				

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

????? ????? pre-existing ? ?????? ???? ??? ????? ????? ??????. ????? ??? ????? ?????? ADOX ????? ??? ?????? ????? ?????? ? ADOX ????? ?????? ??? ???? ?????? F1 ?? ?????? A ???? ????? ?? ?? ???? ?????? ??? ?????? ADOX ???? ?? ?????? B ???? ?????. ????????? ???? ??? ADOX ???? ???? ?????? ?????? ????? ?? ???? ??????? ???????. ??? ????? ??? ??? ????? ??? ?????? ????? ?? ?????? Columns ??? ????? ?????? ADOX ????? ????? ?? ????? ????? ??? ??? ????? ?????? ??? ??????? ???? nonetheless.

??? ?????

?? ????? ??? ???? ?? ???? ADOX ?? Excel.
  • ??? ??? ?????? ????? ??? ??? ?????? ???? ??? ????? ???? ??? ??? ??? "??????" ? "??? ??????.
  • ??? ??? ?????? ????? ??? ???????? ??? ????? ????? ?? ???? ????? ????? ???????:
    ????? ??? ?????.

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

??? ??? ?? ????? ???? ??? ????? ??? ????? ????? ????? .Type ?????? ??? ??? ??? ?????? ????? ? ???? ????? ????? ???????:
??? ????? ???????? ?? ??? ??????.

????? ???????? ??? Excel ????? ??????

????? ???? ????????? ??? ADO ?? Excel ?? ???? ????? Visual Basic ?? ????? ?????? ???? ???? ?????? ????? ?????? ????? ?? ????? ????? ????? ???????:
????? ????? ????? ??? ?????? ?? ??? ???? ???????.
???? ????? ????? ????? ???; ?? ???? ??? ????? ??? ??????? ??????? ???????. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
246167PRB: ????? ????? ??? ??? ADODB Recordset ????? ????? ????? Excel XLS

????? ???????? ??? Excel ??????? ???? ????? ?????? ADOX

??? ??????? ADO ????? ?? ????? ???????? ?? ??????? ???????? ???? ?? ??????? ?? Excel ???????? ADOX ????? ADO ????? ???????? ???? ?????? ?? ??? ??????? ??? ????? ?? ??? ??? ??? ??? ????? ??? ?????????.
  • ??? ????? ???? ??? ????? ???? ?????? ????? ?????? ?????. ??? ????? ?? ???? ??? ?? ???? ???? ????? ???? ??? ??????? ?????? ???? ????? ??????.
  • ??? ????? ????? ????? ???? ?? ???? ?? ?????? ??????? ?? ??? ??? ???? ?? ???? 80040e21 ?????:
    ????? ????? ?????? ??????? ?????. ???? ?? ?? ???? ????.

????? ???????? ??? ????? Excel ???????

??? ??????? ADO ????? ?? ????? ???????? ?? ????? ??? Excel ?? ???????? ???? ??? ??????? ?? ??????? ???????? ADOX ??? ??? ??? ???? ??? ??? ???????? ???? ????? ???????.
  • ??? ????? ????? ???? ???? ????? ?????? ????? ??????.
  • ???? ??????? ?????? ??? ??????. ?? Excel 2002? ??? ??? ????? ????? ?? "??????? ??????" ???? ???? "??????? ??????? ???". ?? ???? ??? ????? ???? ??? ??? ????? ?? ???????? ? ???? ??? ??? ?? ?? ????? ???????? ?? Excel ???????? ?????.

??????? CREATE SQL ? ALTER DROP ????????

????? ????? Microsoft SQL ?????? ????? ????? (DDL) ?????? ??? CREATE ? ALTER DROP ????? ?????? ????? ?????? Excel ??? ADO ????? ?????? ??? ??????? ??? ????? ADOX ??????? ??????? ?????.

?????

  • ADOX ???? ???? ???? ?? Excel ??? ???? ???? ?? ??? ???? ?????? ?? ????? ?? ??? ?????.
  • ???? ADO ???? ???? ?? ?????? Excel ??? ????? ???????? ?? ???? ??? ???? ?? ??????? ???????? ADOX.

???????

???? ???????: 303814 - ????? ??? ??????: 25/????? ??????/1425 - ??????: 2.2
????? ???
  • Microsoft Data Access Components 2.0
  • Microsoft Data Access Components 2.1
  • Microsoft Data Access Components 2.5
  • Microsoft Data Access Components 2.6
  • Microsoft Data Access Components 2.7
????? ??????: 
kbmt kbdatabase kbhowto kbiisam KB303814 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????303814

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

 

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