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

?????? ????????? ?????? ?????????
???? ???????: 295646 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

??? Microsoft Excel ??? ??? ?? ???? ????? ?????? ????? ???? ?????? ????????? Visual Basic ? VBA ?????? ?????? ???????? ??? ???? ??? Excel ?????? ???????. ???? ??? ??????? ????? ?????? ?????? ActiveX (ADO) ??? ?????? ????? ???????? ???? ?????? ?????? ?? Microsoft Jet ?????? ??? ??? ??????? SQL.

???? ??? ??????? ???? ????? ??? ??????? ??? ?? ??? ????? ????? ??????? ???????? ????? ??? ??????? ?? Excel (?? ???? ?????? ??? ??????? ???) ?? ??????? Microsoft Query (?? ?????? ????? ?????? ?????? ?? ??????? ??????).

?????? ??? ??????? ?????? ??? ???? ????? ??????? ???? ?????? ????? Excel ????? ?? ????? SQL ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
246335????? ??? ???????? ?? ?????? ????? ADO ??? Excel ???????? ???????

??????? ????

?? ??????? ??????? cnSrc ???? ????? ADO ????? ??? ????? Northwind ????? ?????? Jet 4.0 ???? Jet OLE DB ????????.

????? ???

???? ??????? ????? SELECT INTO ??? ?????? ?? ?? ???? ?????? Jet ???? ??????? ??? ?? ???? ???????? ?????? ???? ???? (?? ?? ???? ???? Excel ???? ??? ?????) ????. ?? ?????? ???? ?????? ??????? ??? ???? ?????? [Sheet1 $] ??? ??????? ??? ??? ???? ????? ????? ??. ???? ?????? ?????? ?????? ?? ??? ?????; ??? ???? ??? ?? ?????? ?????? ??? ??? ?????.

???? ???? ??? ????? ????? copy ??? ???? ??????? ?????? ?? ????? ?????? Microsoft Access Northwind ??? ???? ????? ?? ???? Excel. ???? ???? ?? ????? ????? SQL ????? ?????? ?????? ??????? ?? ???? ????? ?? ???? ????? ??????.
  • ?????? ?????? ?????? ???? ???? SELECT INTO:
    Dim strSQL As String
    strSQL = "SELECT * INTO [Excel 8.0;Database=" & App.Path & _ 
        "\book1.xls].[Sheet1] FROM Customers"
    cnSrc.Execute strSQL
    					
  • ?????? ?????? ?????? ???? ???? SELECT INTO IN...:
    strSQL = "SELECT * INTO [Sheet1] IN '' [Excel 8.0;Database=" & App.Path & _
        "\book1.xls] FROM Customers"
    						
    ??? ??????? ??????? ????? ???????? ?????? bracketed ?????? ??? ????? ?? ?????? ???????? ??????? ????? ??? (????? "Excel 8.0") ? ???? ??? ?????? ???? ??????? ????? ?????? ???? ?????? ??????.
  • ?????? ?????? ?????? ???? ?????? ???? ?? ???? IN:
    strSQL = "SELECT * INTO [Sheet1] IN '" & App.Path & _
        "\book1.xls' 'Excel 8.0;' FROM Customers"
    						
    ??? ????? ??? ???? ????? ???? ????? ??? ???? ????? ??????.

????? ?????

????? ??????? ????? INSERT INTO... IN ?????? ???????? ?? ?? ???? ?????? ???? ??????? Jet ?? ?????? ??? ??????. ??? ?? ?????? ?????? ?????? ?????. ????? ??? ?? ??? ??????? ??? ???? ??? ??????, ??? ???? ??????? ???????? ??????? ??????, ??? ???? ??????? [Sheet1 $] ??? ??????? ??? ??? ???? ????? ????? ??. ???????? ??? ???? ??? ?? ???? ?????? ??????? ?????? ??????; ????? ???? ???? ??? ???? ???????? ??? ????? ???? ?????.

???? ??????? ????? ????? append ??? ???? ??????? ?????? ?? ????? ???????? Northwind ??? ???? ??? ?????? Excel ? ????? ????? ?????? ??? ???? ??????? ????????.
  • ?????? ?????? ?????? ???? ???? INSERT INTO IN...:
    strSQL = "INSERT INTO [Sheet1$] IN '' [Excel 8.0;Database=" & App.Path & _
        "\book1.xls] SELECT * FROM Customers"
    						
    ??? ??????? ????? ???????? ?????? bracketed ?? ??? ???? ?????? ??? ????? ?????? ???????? ?? ??? ??????? ??? ???? ????? ???? ???????.
  • ?????? ?????? ?????? ???? ?????? ???? ?? ???? IN:
    strSQL = "INSERT INTO [Sheet1$] IN '" & App.Path & _
        "\book1.xls' 'Excel 8.0;' SELECT * FROM Customers"
    					

?????

?????? ??? ??????? ?????? ??? ???? ?????? ?????? ?? Jet ?????? Jet SQL ??? ????????? (JETSQL40.chm) ???????? ?? ????? SELECT INTO ? ????? INSERT INTO ???? IN ????.

???????

???? ???????: 295646 - ????? ??? ??????: 29/???/1427 - ??????: 2.4
????? ???
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Visual Basic 5.0 Enterprise Edition
  • Microsoft Visual Basic Enterprise Edition for Windows 6.0
  • Microsoft Visual Basic 5.0 Professional Edition
  • Microsoft Visual Basic 6.0 Professional Edition
  • Microsoft Data Access Components 2.0
  • Microsoft Data Access Components 2.1
  • Microsoft Data Access Components 2.5
  • Microsoft Excel 97 Standard Edition
????? ??????: 
kbmt kbdatabase kbhowto kbjet kbmdacnosweep KB295646 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????295646

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

 

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