http://expert.csdn.net/Expert/topic/2341/2341997.xml?temp=.2739221
SQL语句导入导出大全insert into openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\',
'select * from [logdate.DBF]')
select * from 表
SQL语句导入导出大全insert into openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\',
'select * from [logdate.DBF]')
select * from 表
并将代码改为::
insert into openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=d:\data\',
'select * from [logdate.DBF]')
select * from 表
就不行了???
insert into openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=d:\data',
'select * from [logdate.DBF]')
select * from 表
呵呵,终于可以了,不过好象有的字段为空,那么执行时就回报错,这是为什么?