SQL to DBF

 insert into openrowset('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\','select * from TableName.dbf')select * from TableName

以上这句话是SQL Server 导出到DBF 中的，其重要注意的是TableName.dbf没有[]。
比如
insert into openrowset
('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\',
'select * from ZYSS')
select * from ZYSS