如在C:\上有xh.dbf数据表,要导入到SQL-Server的newcf数据库中,生成student新表
两步:
1. 开启Ad Hoc Distributed Queries模式
EXECUTE sp_configure 'show advanced options',1
RECONFIGURE
EXECUTE sp_configure 'Ad Hoc Distributed Queries',1
RECONFIGURE
2.导入
select * into student
from openrowset('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver; SourceDB=C:\; SourceType=DBF', 'select * from xh ')