--试试: select convert(decimal(5,3),dj) from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\jsbold\a2003文件夹','select * from [slk0301.DBF]')
我认为可以先导入数据库 导入如果正确,那再sql中查询肯定没问题
检查原slk0301.DBF文件中的数据是否规范合理. 先用少些数据进行测试,找出原因.
我已搞定 select dj from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\jsbold\a2003文件夹','select ntom(dj) from [slk0301.DBF]')
select convert(decimal(5,3),dj) from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\jsbold\a2003文件夹','select * from [slk0301.DBF]')
导入如果正确,那再sql中查询肯定没问题
先用少些数据进行测试,找出原因.
select dj from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\jsbold\a2003文件夹','select ntom(dj) from [slk0301.DBF]')