网上流传的方法都是SQL SERVER跟DBF在同一台机器上的做法,
'sql = "select * into [dBase III;database= C:/]. abc from export "
'sql = "select * into [Excel 8.0;database=C:/].abc from q1 "
'sql = "select * into abc IN odbc[dBase 5.0;database=C:/] from q1 in ODBC[ODBC;Driver=SQL Server;UID=sa;PWD=;Server=127.0.0.1;DataBase=EV2_GPRS];"
'sql = "select * into abc in odbc[dBase Ⅴ;database=abc.dbf] from user_data in ODBC[ODBC;Driver=SQL Server;UID=sa,PWD=,Server=127.0.0.1,DataBase=EV2_GPRS];"
(这些都是网上流传最多的方法)
试了以上方法都出错,
'sql = "Insert Into openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:/','select * from abc.DBF') Select * From export"
(该方法只能在服务器上导出