????? ???? ???? ??????? ?????? ?????? ???? ???? ????? ??? ?? ???? ?? ??? ??? ????? ?? Access 2003 ??? ????? ???? ?????? Service Pack 3 ?????? ?? Office 2003

?????? ????????? ?????? ?????????
???? ???????: 945280 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

???? ??? ????????? ??????:
  • ???? ??????? ?????:
    • Microsoft Office Access 2003
    • Microsoft Office 2003 Service Pack 3 (SP3)
  • ????? ???? ???? ???? ????? ???? ?? ???? ???? ???? ????? ??? ????? ?? ?????.
  • ????? ????? "???? ????" ???? ?????? ??? ????? SQL.
?? ??? ?????????? ????? ??? ??????? ???????.

??????

???? ???? ?????? ??? ????. ??? ???? ????? ???? ?????? ???? ????? ?? ????? ???? ??? ?????? ?????? ????? SQL.

?????? 2

???? ???? ?????? -1 ???? ??? ? 0 ?????? ??. ??? ???? ????? ???? ?????? ???? ??? ???? ??? ? ?? ???? ??.

?? ???? ?????? ????? ??? ?? ??????? Access 2003 ???? ?? Access 2003 ?? ???? ?????? Office 2003 SP3.

?????

??? 1

???? ??? ??????? ??? ???? ??? ?????? ???????:
  • ????? ????? SQL ??? ??? ??????? ?? ?? ?? ????? ????? ??? ???? ?????.
  • ????? ????? SQL ??? ???? ?? ?? ???? ???? ???? ??? ???? ??? Excel. ???????? ??? ???? ????? ??????? ???? ????? ??? ??? ????? ?? ???? ??? Excel ??????? Text.
?????? ??? ??? ???????? ???? ???? 1.

??? 2

???? ??? ??????? ??? ????? ????? SQL ??? ??? ??????? ?? ????. ?????? ??? ??? ???????? ???? ???? 2.

???? ??????

???? ?????? 1

??????? ?????? ??? ??? ??????? ?????? ???? ????? ???????? ????? ??? ??? ???????.

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

????? ????? ????? ???? ?? ????? ??? ?????. ?????? ????? ???? ??????? ???????.

?????? ?????? ??? ??????? ????? ???? ????? ????? ?? ??? "????? 1" ??????.
  1. ???? ?????? ???? ????? ??? ??? ????? ?? ????? ????? "?????".
  2. ??? ???? ????? ?? ???? ??? ????? ??????? ???.
  3. ?? ???? "?????" ?? ????? ??????? ??? ??? ??????? ???? ?? ???????.
  4. ?? ??????? ???? ???? ??? ???.
  5. ?? ??????? ???? ???? ??? ?????.

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

????? ????? SQL ?????? "" ??? ????? ??????? "???? ????". ?????? ????? ???? ??????? ???????.

?????? ?????? ??? ??????? ????? ???? ????? ?????? ?? ????? "????? 1" ??????.

??? ???? ??????? ???? SQL ??? ???:
SELECT FieldName FROM LinkedSpreadsheetName
??????? ????? SQL ??? ???:
SELECT FieldName & "" FROM LinkedSpreadsheetName
?????? ??? ??????? ??????? ???? ??? ??????? Text ?? ???? ??? Excel 2003 Access ???????? ?????? ????? ????? ??? @ (??? ?????) ????? ?????? ????????.

???? ?????? 2

??????? ?????? ??? ??? ??????? ???? ??????? ???????:
  1. ????? ????? SQL ??????? "???? ????" ?????? ?????? ????????. ??? ???? ??????:
    • SQL ?????? ????? ???? ???? ?????? ???? ??? ???? ??? ? ?? ???? ??.
      SELECT TableName.YesNoFieldName, IIf([YesNoFieldName]=-1,"Yes","No") AS YN_Value FROM TableName
    • SQL ?????? ????? ???? ???? ?????? ???? True ???? ??? ? ??? ???? ??.
      SELECT TableName.YesNoFieldName, IIf([YesNoFieldName]=-1,"True","False") AS YN_Value FROM TableName
    • SQL ?????? ????? ???? ???? ?????? ???? ??? ???? ??? ? ????? ???? ??.
      SELECT TableName.YesNoFieldName, IIf([YesNoFieldName]=-1,"On","Off") AS YN_Value FROM TableName
  2. ???? ?? ?? ???? ???? ?????? ???? ????. ?????? ????? ????? ?????? ???????? ????? ???? ??? ?? ???? ?? ?????? ?????? ??? ???????.
?? ??? ??????????? ??? ??????
???????????
???? ????1
??? ???????2
??? ??????0 "; 0.5"

????

??? ??? ???????? ??? ?????? ??? Access 2003 post-Service Pack 3 ???? ????????? ??????? ?????? 18 ?????? ????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
945674??? ????? ????????? ??????? ??????? ????? ?????? Service Pack 3 Access 2003: 18 ?????? ????

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".

???????

???? ???????: 945280 - ????? ??? ??????: 23/?? ?????/1428 - ??????: 2.1
????? ???
  • Microsoft Office 2003 Service Pack 3, ????? ?????? ??:
    • Microsoft Office Access 2003
????? ??????: 
kbmt kbexpertiseadvanced kbtshoot kbprb KB945280 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????945280

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

 

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