Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

dbf±íµ¼Èëµ½sql server2000±íÎÊÌâ

ÇëÎÊ£º
1,ÈçºÎ½«Ò»ÕÅdbf±íµ¼Èëµ½sql server2000ÖеÄÒ»ÕÅ±í¡£Ê¹ÓÃDTS¸ÃÔõÑùʵÏÖ£¿
2,ʹÓÃÍøÉÏ´úÂ룺
Insert Into Tb_cj Select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:','select * from F:\MyWeb\094ʵ¼ù³É¼¨.DBF')
±¨´í£º
OLE DB Ìṩ³ÌÐò 'MSDASQL' ±¨´í¡£
[OLE/DB provider returned message: [Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] Çý¶¯³ÌÐò²»Ö§³Ö´Ë¹¦ÄÜ]

ÇëÎʸ÷λ¸ßÈËÈçºÎ½â¾ö¸ÃÎÊÌ⣬ÏÈл¹ý¡£
¹¤¾ßµ¼Èë1£ºÍ¨¹ýSQL ServerµÄ¡°µ¼Èëµ¼³öÊý¾Ý¡±¹¤¾ß£¨DTS£©

1¡¢½¨Á¢Visual FoxProµÄÊý¾ÝÔ´£º

ÔÚODBCÖн¨Á¢Ò»¸öVisual FoxProµÄÊý¾ÝÔ´(ODBC-Microsoft Visual FoxPro Driver)µÄ²½ÖèÈçÏ£º
´ò¿ªODBCÅäÖÆ´°¿Ú ->
Ñ¡Ôñ¡°Óû§DSN¡±Ò³Ãæ»ò¡°ÏµÍ³DSN¡±Ò³Ã棬½¨ÒéÓúóÕß ->
µã»÷¡°Ìí¼Ó¡±°´Å¥ ->
Ñ¡Ôñ¡°Microsoft Visual FoxPro Driver¡±Õâ¸öÇý¶¯ ->
ÔÚData Source Name£¨ÊýÔ´Ô´Ãû³Æ£©´¦ÊäÈë´ËÊý¾ÝÔ´Ãû³Æ£¬¿É×Ô¶¨£¬±¾ÀýÈçLjDbf£¬Database Type£¨Êý¾Ý¿âÀàÐÍ£©´¦Ñ¡Ôñ¡°Free Table directory¡±(×ÔÓɱí·¾¶)£¬È»ºóÔÚÏÂÃæµÄPath£¨Â·¾¶£©´¦ÉèÖÃÄãÒªµ¼ÈëµÄDBF±íËùÔڵķ¾¶£¬±¾ÁÐÈç¡°D:¡± ->
µã»÷¡°OK¡±£¨È·¶¨£©ÅäÖÆÍê³É ->
¹Ø±ÕODBCÅäÖÆ´°¿Ú

2¡¢Í¨¹ýSQLµÄµ¼Èëµ¼³öÊý¾Ý£¨DTS£©À´°ÑDBF±íµ¼³ÉSQL±í£º

¿ªÊ¼ ->
³ÌÐò ->
Microsoft Sql Server£­µ¼Èëµ¼³öÊý£¨DTS£©->
ÏÂÒ»²½ ->
´Ë²½Îª¡°Ñ¡ÔñÊý¾ÝÔ´¡±µÄ´°¿Ú£¬¡°Êý¾ÝÔ´¡±Ñ¡¡°Microsoft Visual FoxPro Driver¡±£¬Í¬Ê±ÔÚ"Óû§/ϵͳDSN"´¦Ñ¡ÔñÄã¸


Ïà¹ØÎÊ´ð£º

ÈçºÎÓÃc#£¬sql2000 ¿ª·¢c/sÏµĹ¤×÷Á÷£¿

±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......

SQL ¶à±í²éѯ²é³öËùÒªµÄÊý¾Ý£¿

ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо­¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿

ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿
ÀýÈ磺
ALTER PROCEDURE [dbo].[sp_1]
@SYS_LNNO varchar(20),
@SYS_CALLER varchar(20),
        @SYS_ORGANIZE varchar(10), ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ