内容如标题, 我是说用SQL语句实现的!
select * into myTableName from
OpenDataSource(Microsoft.Jet.OLEDB.4.0,
Data Source="c:\aaa";User ID=Admin;Password=;Extended properties=dBase 5.0)
...bbb
select * from OpenDataSource(Microsoft.Jet.OLEDB.4.0,Data Source="c:\报表";User ID=Admin;Password=;Extended properties=dBase 5.0)...fh200303
1:建立DBF的ODBC驱动,如dbfdata;一定要选择合适的驱动。
2:insert into table1
select * from
OPENROWSET(MSDASQL,DSN=dbfdata,select * from aaa.dbf)
备注:一般错误可能是驱动错误,如DBASEIII的DBF以VFP的驱动就打不开。
select * from OpenDataSource(Microsoft.Jet.OLEDB.4.0,Data Source="c:\报表";User ID=Admin;Password=;Extended properties=dBase III)...fh200303
--/* dBase IV文件
select * from
OPENROWSET(MICROSOFT.JET.OLEDB.4.0
,dBase IV;HDR=NO;IMEX=2;DATABASE=C:\,select * from [客户资料4.dbf])
--*/
--/* dBase III文件
select * from
OPENROWSET(MICROSOFT.JET.OLEDB.4.0
,dBase III;HDR=NO;IMEX=2;DATABASE=C:\,select * from [客户资料3.dbf])