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#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿
ÀýÈ磺
ALTER PROCEDURE [dbo].[sp_1]
@SYS_LNNO varchar(20),
@SYS_CALLER varchar(20),
@SYS_ORGANIZE varchar(10), ......