发信人: 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"'
----
天行健，君子以自强不息
|
|