导入远程的DBF文件到本地的SQL ( 积分: 100 )

S

shadowpj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-08-16

• #1

SELECT * INTO SQL表 FROM Openrowset(′MSDASQL′,′Driver=Microsoft Visual FoxPro Driver;SourceDB=dbf路径;SourceType=DBF′,′select * from dbf表名′)";
这里的DBF路径写成远程的IP怎么不行啊.本地的地址可以.哪个晓得.急!

 

X

XF.Lian

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-08-16

• #2

可以用共享路径的 //ComputerName/ShareName/DBFFileName 不过要确保有读取此文件的权限

 

S

shadowpj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-08-21

• #3

不行哦。我是这样写的。
insert qy_dw select * from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;
SourceDB=//192.168.1.17/i/HBSB/SJ/',
'select dwbh,dwmc from [dw0_.DBF]')
I盘是共享的.我把iP换成computerName一样不行.

 

D

dean_2008

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-08-23

• #4

把远程的文件先弄到本地然后在导入。呵呵。也未尝不可阿！