insert into openrowset(’MSDASQL',’Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\’, ’select * from [aa.DBF]’)
--/* FoxPro 数据库 select * from openrowset('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\', 'select * from [aa.DBF]') --*/
/**************导入DBF文件****************/ select * from openrowset('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver; SourceDB=e:\VFP98\data; SourceType=DBF', 'select * from customer where country != "USA" order by country') go /***************** 导出到DBF ***************/ 如果要导出数据到已经生成结构(即现存的)FOXPRO表中,可以直接用下面的SQL语句
insert into openrowset('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\', 'select * from [aa.DBF]') select * from 表
说明: SourceDB=c:\ 指定foxpro表所在的文件夹 aa.DBF 指定foxpro表的文件名. 我知道这个方法!用sql server 导入导出工具该如何操作呢??
insert into openrowset('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver; SourceDB='+@path+'; SourceType=DBF', 'select * from cbdbf') select * from table
我按着上面的方法写都报错啊?? insert into openrowset('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\test', 'select * from [aa.DBF]')
’select * from [aa.DBF]’)
select * from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\',
'select * from [aa.DBF]')
--*/
/**************导入DBF文件****************/
select * from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;
SourceDB=e:\VFP98\data;
SourceType=DBF',
'select * from customer where country != "USA" order by country')
go
/***************** 导出到DBF ***************/
如果要导出数据到已经生成结构(即现存的)FOXPRO表中,可以直接用下面的SQL语句
insert into openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\',
'select * from [aa.DBF]')
select * from 表
说明:
SourceDB=c:\ 指定foxpro表所在的文件夹
aa.DBF 指定foxpro表的文件名.
我知道这个方法!用sql server 导入导出工具该如何操作呢??
openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;
SourceDB='+@path+';
SourceType=DBF',
'select * from cbdbf')
select * from table
insert into openrowset('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\test', 'select * from [aa.DBF]')
C:\test aa.dbf就是C:\test下的文件啊!