ãã常è§çæ°æ®å¯¼å
¥å¯¼åºï¼
ãã使ç¨DTSå导è¿ç§»ä½ çAccessæ°æ®å°SQL Serverï¼ä½ å¯ä»¥ä½¿ç¨è¿äºæ¥éª¤:
ããâ1å¨SQL SERVERä¼ä¸ç®¡çå¨ä¸çTools(å·¥å
·)èåä¸ï¼éæ©Data Transformation
ããâ2Services(æ°æ®è½¬æ¢æå¡)ï¼ç¶åéæ© czdImport Data(导å
¥æ°æ®)ã
ããâ3å¨Choose a Data Source(éæ©æ°æ®æº)对è¯æ¡ä¸éæ©Microsoft Access as the Sourceï¼ç¶åé®å
¥ä½ ç.mdbæ°æ®åº(.mdbæ件æ©å±å)çæ件åæéè¿æµè§å¯»æ¾è¯¥æ件ã
ããâ4å¨Choose a Destination(éæ©ç®æ )对è¯æ¡ä¸ï¼éæ©Microsoft OLEãDB Prov ider for SQLãServerï¼éæ©æ°æ®åºæå¡å¨ï¼ç¶ååå»å¿
è¦çéªè¯æ¹å¼ã
ããâ5å¨Specify Table Copy(æå®è¡¨æ ¼å¤å¶)æQuery(æ¥è¯¢)对è¯æ¡ä¸ï¼åå»Copy tables(å¤å¶è¡¨æ ¼)ã
ããâ6å¨Select Source Tables(éæ©æºè¡¨æ ¼)对è¯æ¡ä¸ï¼åå»Select All(å
¨é¨éå®)ãä¸ä¸æ¥ï¼å®æã
温馨提示:内容为网友见解,仅供参考