HOW: ??????? ??? ???????? ??? Excel ???????? ????? ?????? SQL Server

?????? ????????? ?????? ?????????
???? ???????: 319951 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

SQL Server ???????? ????? ????? (DTS) ?? ???? ????? ????? ????????? ???? ???????? ?????? ??? ????? ?????? OLE DB ?????? ???????? ??? ?? ??????? (??? ????? ?????? ????). ???? ??? ??????? ????? ??????? "?????" ?????????/??????? DTS ????? ???????? ?? Microsoft SQL Server ?? ?? ???? ?????? ??? ??? ???? ??? Microsoft Excel. ????? ?????? ?? ??? ???????? ??? ??? ???? ?????? ?????? "????? ????????" ?? ???? DTS.

???????

???? ??????? ??????? ??????? ?????? ??? ????? ?????? ???????? ?????? ? ??? ??????? ???? ???????:
  • Microsoft SQL Server 2000 ?? Microsoft SQL Server 7.0 ?????? ??? ???? ????? Microsoft Windows ??????.
  • Microsoft Jet 4.0 ????? ??????? ???????? ?? ???? ????? ?????? MDAC ??????? 2.1 ?? 2.5 ?? ?????? ???? ???.
????? ??? ??????? ???? ?????? ???????? ??? ????? ?? ???????? ???????:
  • ???? SQL
  • ????? ????? ????????
  • ????? ??? Excel

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

  1. ??? ????? "?????" ?????????/??????? DTS ?? ??? ???? ?????? ??? ????? ??????? ?????? "???? ??????". ??? ????? ???? ?????? ????????? ??????? ??? ????? ??????? ?????? ????.
  2. ?? ??????? ?????? ???? ??? Microsoft Excel 97-2000 ???? ????? ???????? ??????. ?????? ??? ????? ?? ??? ??????? Microsoft Excel 2002 (Microsoft Office XP).
  3. ?? ?????? ??? ????? ? ???? ??? ????? ????? ?????? ???? ??? ???? Excel ?????. ??? ?? ?? ???? ??? ????? ????? ?? Excel ????? ??? ????? ???????. ??? ??? Excel ???? ??? ?????????? ????? ????? ??? Excel ???? ?? ??? ??????? ??? ??? ???????. ?????? ????? ???? ??? ?????? ?????? ??? ???? ????? ??? ? ??? ??? ???? ?? ???? ??? ???? ??? Microsoft Excel.

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

  1. ???????? ??????? ?????? (??????? ????? ????) View(s) ?? ??????? ?? ???? ?????? ??? ?????? ?? ??? (?? ?????? ??????? ????) ???? ???? ????? ??? Excel.
  2. ???? ???????? ??????? ?????? ??? ???? ???? ?? ??? ????? ??? ????? ?????? ?? ?????? ??????.

    ??????: ??? ?????? ???? ??? ????? ????? ???? ????? ?? ?????? ?????? ? ??? ???? ?????? DTS ???? ???? ?? ???? ???????.

    ???? ????? ????? ???? ??? ?????? ?? ????? ???? (??????? ???? ???? ?????? $ $ ??????1 ????? ????? ?????).
  3. ?? ?????? ????? ???? ??? ????? ????? ???? ???? ???? ?????? ???? ??? ?????? ??? ??? ???????? ???????:
    • ????? ???? ??????

      ??? ?? ?????? ????? ??? ?? ???? ??? ???? ?????? ?????? ???. ??? ??? ?????? ??????? ??????? ??? ?????? ??? ?????, ??? ??? ?????? ???? ???? ?????? ????? ?? ????? ????? ??????.
    • ??? ?????? ?????? ???????? ??????????

      ??? ????? ??????? ??? ?????? ?? Excel ??? (???? ?? ????? ????????).
    • ????? ???? ????? ??? ?????? ????????
  4. ?? ??????? ???????? ?? ??????? ????? ??? ???? DTS ???????. ?????? ???????? ??????? ?? ???? ?? ??????? ???? ????? ???? ????? ?????? ???? ??????? ??? ????? ???????.

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

????? ??? Excel

  • ?? ???? ???? ???? Excel ??? ????? ??? ????? ??????? DTS.

????? ???? Excel

  • ??? ??? ?????? ?????? ????? ?? ????? ????? ?????? ?????? ???? ????? ??????? ?? ????? ?????? ???? ???? ?????? ?????? ???? ??? ???? ??????; ??? ???? ??? ???????.
  • ??? ??? ?????? ????? ?????? ?????? ???? ???? ????? ?? ????? ????? ???? ????? ????? ??? executions ??????? ???? ???? ?????? ??????; ??? ???? ??? ???????.
  • ?? ???? ????? ????? CREATE ????? Excel? ??? ????? ???? ??????? ??? ?????? ???? ??? ????? ????? ???? ?????; ??? ???? ???? DTS ?? ?????? ????? ??? ?? ??? ????? ???? ???. ???? ??? ?????? ????? ?? Excel: ?? ??????? ????? ? ???? ??? ????? ?? ???? ??? ?????.
  • ?? ???? ??? ?? ?????? ?????? ???????? ?? ???? ?????? ????? ???? ?? ???? ??? ???? ???? ??? Excel ???? OLE DB.
  • ??? ??? ?????? ?? ???? ???? ???????? ???? ?? ??????? ?? ???? ????? ?????? ????? ???????? ??? ???? ???? ???????? ??????? ????? ???? ???? ????? ??? ?????? ??????? ???? ??? ????? ???????? ???? ???? ?? ??? ??????? ?????? ???????. ??? ??? ???? ???? ?????? ??????? ?? ???? ???????? ?? ???? ??? ??? ?????? ???? ??? ?????? ????? ????? ???? ???? ????????. ??? ???? ??? ?????? ??????? ?????? ????? ?? ????? ????? ???????? ???????? ????????.

?????

?????? ??? ??????? ?????? ??? ???????? ???? ??????? ??? ??????? Excel ?????? ?????? ? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
257819HOWTO: ??????? ADO ?? ?????? Excel ?? Visual Basic ?? VBA
?????? ??? ??????? ?????? ??? ???????? ???????? ???? ??????? ??? ??????? Excel ?? DTS ???? ??? ???? ????????? ????????? ??????? ?? "????? ??????? ?? Microsoft:
236605PRB: ????? DTS ?? ??? ??? ??? ?????? Excel ?????? ??????
281517PRB: ??? ??? ?????? ?? ???? Jet 4.0LEDB ?? ??? ????? ??? ?????? ??????
207446BUG: ?? ???? ??????? ???? ?????? Excel 97 ????? ?????? 256 ?? ????

?????? ??? ??????? ?????? ??? ????? ??????? ???? SQL Server DTS ???? ???????? "??? SQL Server ???????" ???????:

"????? ????? ????? ?? SQL Server ??? Excel"
"????? ???? DTS ???????? ????? ?????????/??????? DTS"
"DTS ??? ?????? ??????? ?????? ??? ????? ?????? ??? ?????????"

???????

???? ???????: 319951 - ????? ??? ??????: 18/????/1424 - ??????: 3.5
????? ???
  • Microsoft SQL Server 2000 64 bit (all editions)
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
????? ??????: 
kbmt kbhowto kbhowtomaster KB319951 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????319951

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

 

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