????? ??????? ???????? ?????? ????? ??????? (DSN) ?? Excel 2000 ?? Excel 2002 ???????? ???????

?????? ????????? ?????? ?????????
???? ???????: 213772 - ??? ???????? ???? ????? ????? ??? ???????.
?????? ??? ????? Microsoft Office 97 ?? ??? ???????? ???? 159557.
????? ???? | ?? ????

?? ??? ??????

??????

????? Microsoft Office ??? ????? ????? ???????? ??????? (ODBC) ????? ??????? ???? ????? ????????? ?????? ??? ???????? ?? ??????? ??????. ???? ??? ??????? ????? ?????? ?? ????? ????? ???????? (DSN) ???? ???? ??????? ?????????? ?? ????? Microsoft Office ???? ??? ?? Microsoft Excel.

??????? ????

??? ????? Microsoft Office? ??? ????? ??? ODBC ???? ????? ODBC ?? "???? ??????". ???? ????? ODBC ????? ?????? ????? ?????? ODBC. ?? ????? ODBC ????? ????? ?????? ??????? ????? ????? ?? DSNs:
  • ?????? DSN
  • DSN ??????
  • ??? DSN

?????? DSN

DSN ???????? ?? ???? ?????? ?????? ?????????. DSN ???????? ?????? ?????? ???? ?????? ??? ???????? ???? ??? ???????. ?? ?????? Microsoft Query DSNs ????????. ?? ???? ??????? ????? Microsoft Jet ?? ODBC ??? ????????? ???????? (SQL) ????? Microsoft Query DSNs ???????? ??????. ??? ????? DSNs ???????? ?? ????? Windows ??? ??????? ??????:
????? ???????? HKEY_CURRENT_USER\Software\Odbc\Odbc.ini\Odbc

DSN ??????

???? DSN ???? DSN ???????? ??? ?????? ?????????. ???? DSN ??????? ?????? ? ??? ???? ?????? ????. ???? ??????? ?? ?????? ???? ?????? ?????? ??? ??????? ???? ???? ????? ?????? ??? ???? ?????? ???? DSN. ??? ???????? ??? Microsoft SQL Server ?? Microsoft Internet ????? ???? ??????? (IIS) ? ???? DSN. ??? ????? DSN ??? ??? ?????? ??? ???? ????????. ??? ????? DSNs ?????? ?? Windows ??????? ??? ??????? ??????:
????? ???????? HKEY_LOCAL_MACHINE\Software\Odbc\Odbc.ini\Odbc

??? DSN

??? ????? ?????? ??? DSN ?????? ???? ???????? ?? ???????? ?????. ??? DSN ???????? ??? ???????? ??? ???? ?? ????? .dsn ????? ??? ???? ????????? ???????? ??????? ????? ????????. ?????? ??? ???? ????? ?????? ????? ODBC ?????? ???????? ??? DSN. ?????? Microsoft Query ??? ?? ?????? DSNs ? ???? Microsoft Jet ?ODBC DSNs ???.

??? ????? DSNs ??? ???? ??????? ?? "????? Files\Odbc\Data Files\Common ????????" ??????. ?? ??? ????? ????? DSNs ?? ????? Windows. ????? .dsn ?? ??? ??? ????? ??? ?? ?? ???? ?? ??? ????? Microsoft.

??????: ??? ????? ??? ??????? ????? ?????? ?????? ???????? Microsoft Query ??? ???? ??? DSNs ???? ??? ??????? ??? ??? ?????????. ?? ???? Microsoft Query ?????? ?? DSNs ??????. ??? ???? ????? ????? ??? DSN ???? ???? ??? ???? DSN.

?????? ??? DSN ???? ???? ??? ???? DSN ? ???? ??????? ???????:
  1. ?? ???? ?? ??? Microsoft Notepad? ???? ??????? ???????? ?? ????? ????
    [ODBC] DSN = MySysDSN
    ??? ???? "MySysDSN" ?? ??? DSN ?????? ??????? ?? ?????? "ODBC" ?? "???? ??????".
  2. ???? ??? ??? ?? ??????? ??? ?? ???? ????? ????? ???? ??? ??? .dsn ?? ??? DSN; ??? ???? ?????? ?????? ??? ????:
    "DBase4.dsn"
    ????? ?????? ???????? ?????? ?? ????? ???? ??? ????? .dsn ???? ????.
????? ????? ?????? ??? DSN ?? ???????? ?????. ?????? ????? ?? ??????? ???? ??? .dsn ??? ????? ????? ???????? ??????? ???????:
  1. ???? ??? ?????? ?????? ??? ???? ?? ???? ??? ???????.
  2. ???? ?????? ???? ????? ??? ????? .dsn. ???? ???????? ???? ?????? "????? Files\Odbc\Data Files\Common ???????".
  3. ???? ??? ?????? ?????? ??? ?????? ?? ???? ??? ??????. ?? ??????? ??????? ???? ??? ???????? ???? ????? ??? ??????? ???????? ?????? ?? ?????? ??? ???????? ?? ???? ??? ?????.
??????: ??? ?? ?? ?????? ????? ?????? ????? ODBC ???????? (?????? ???? ??? ??? DSN) ??? ???? ????????? ?? ??? DSN ???? ????.

????? ???? ????? ?????? ?????? ??? Microsoft Excel


???? Microsoft ??????? ???????? ??? ??? ?? ???? ??????? ?? ?? ????? ? ? ?? ????? ??? ?????? ???????? ??????? ?/?? ???????? ???? ????. ????? ??? ??????? ??? ????? ??? ??? ??????? ???? ?? ????? ???????? ????????? ?????? ????????? ????????. ???? ?? ????? ??????? ????? Microsoft ??? ????? ????? ???? ???? ?? ?????? ?????? ??? ??????? ?????? ????? ?????? ?? ????? ??????? ?????? ????????? ???????.
??? ??? ??? ?? ???? ???? ???? ?????? ?? ???? ???????? ?? ????? ??? ??????? ????? Microsoft ?? ????? ???????. ????? ?? ?????????? ?? ?????? ????? ??? Microsoft ???:

Microsoft ????????? Partners ? https://partner.microsoft.com/global/30000104

????? Microsoft ??????? ???? ???? ??????? - http://support.microsoft.com/gp/advisoryservice

?????? ??? ???? ?? ????????? ??? ?????? ????? ???????? ???? ????? ??????? ????? Microsoft ?? ?????? ???? Microsoft ?????? ??? ?????: http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS

???? ??????? ??????? Microsoft Excel ????? Visual Basic for Applications ?????? ????? ?? ???? DSN ??????? ???????? ?? ????? ?????? ?????? ???????? ?? ???? ???. ????? DSN ????????? ?? ??? ??????? ????? MyDSN. ???? ????? Microsoft Access ????? ???????? Northwind.mdb ?? ?????? Office\Office\Samples Files\Microsoft ???????. ????? ??????? MyDSN ???????? ?? ???? DSN ????? ?? ????? ?? ??????? ??? ??? DSN.
Sub Get_Data()
    'Define SQL query string to get the CategoryName field from
    'the Category table.
    sqlstring = "SELECT CategoryName FROM Categories"
    'Define connection string and reference File DSN.
    connstring = "ODBC;DSN=MyDSN"
    'Create QueryTable in worksheet beginning with cell C1.
    With ActiveSheet.QueryTables.Add(Connection:=connstring, _
        Destination:=Range("C1"), Sql:=sqlstring)
        .Refresh
    End With
End Sub
				

?????

????? ?? ????????? ??? ??????? ????????? ???? ??? ??????? Microsoft Excel ?? ??????? ??????? ? ???? ??? ??????? ???????? ?? ????? ?????? ?????? ?? ????? Office "??" ????? ??????? ?? ???? ??? ??? ???? ???????.

???????

???? ???????: 213772 - ????? ??? ??????: 05/????/1428 - ??????: 3.6
????? ???
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2002 Standard Edition
????? ??????: 
kbmt kbquery kbdtacode kbhowto kbprogramming KB213772 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????213772

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

 

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