在MSSQL2000中使用Transact-SQL语句处理DBF数据转换

精华区

当前位置：网易精华区>>讨论区精华>>编程开发>>● VFP>>〖多层应用〗>>在MSSQL2000中使用Transact-SQL语句处理DBF数据转换

主题：在MSSQL2000中使用Transact-SQL语句处理DBF数据转换

发信人: foxzz()
整理人: foxzz(2003-08-14 09:13:01), 站内信件

请参考：

1、查询dbf数据
SELECT * FROM OpenDataSource('vfpoledb','Data Source="d:\vfp\test.dbc"')...test1

SELECT a.*
FROM OPENROWSET('MSDASQL',
'DRIVER={Microsoft Visual FoxPro Driver};
Exclusive=No;Collate=Machine;Deleted=Yes;Null=No;
SourceDB=d:\vfp\test.dbc;SourceType=DBC;',
'SELECT * FROM test1') AS a

Select *
   From Openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;
   SourceDB=d:\vfp\;SourceType=DBF',
   'select * from test3')

2、将DBF数据导入mssql中
SELECT * into test1 FROM OpenDataSource('vfpoledb','Data Source="d:\vfp\test.dbc"')...test1

3、将SQL数据导入dbf中
insert into  OPENROWSET('MSDASQL', 'DRIVER={Microsoft Visual FoxPro Driver}; Exclusive=No;Collate=Machine;Deleted=Yes;Null=No; SourceDB=d:\vfp\test.dbc;SourceType=DBC;', 'SELECT * FROM test1') select * from Test1

4、修改数据
Update openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceDB=d:\vfp\;SourceType=DBF','select * from test3 where code="11"') set name = '"12"'

----
天行健，君子以自强不息

[关闭][返回]