--/* FoxPro 数据库
select * from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\',
'select * from [aa.DBF]')
--*/
select * from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\',
'select * from [aa.DBF]')
--*/
您给我的这一句是不是c:\aa.dbf中的内容,拷至sql server数据库中的同名aa表中吗?
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\',
'select * from [aa.DBF]')
select * from 要复制的SQL表--注意,DBF文件必须已经存在,
openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\',
'select * from [aa.DBF]')
insert into lotphd
openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\',
'select * from [aa.DBF]')提示:在关键字openrowset 附近有语法错误,请问错在哪里呢?
insert into lotphd
select * from
openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\',
'select * from [aa.DBF]')
对 text 数据类型不支持代码页转换。从: 936 到: 950。记住:这个lotphd是原来从sql server导出来生成的lotphd.dbf文件,可现在要导回去,却提示这样的错误!奇怪!是什么原因呢?请再指教!tks
select * into #tb from
openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\',
'select * from [aa.DBF]')insert into lotphd select * from #tbdrop table #tb
服务器: 消息 7399,级别 16,状态 1,行 1
OLE DB 提供程序 'MSDASQL' 报错。
[OLE/DB provider returned message: [Microsoft][ODBC Visual FoxPro Driver]Cannot open file d:\sqlbf\ctb0.dbf.]
怪事!