vfp数据库目录 \\sydtms01\e$\Translogix\Data\DATA_A
要导出的表文件 spjobs.dbf
导入到dbf_run_01表中，此表不存在，需新建
我的SQL
select * into dbf_run_01 from
openrowset('MICROSOFT.JET.OLEDB.4.0'
,'dBase III;DATABASE=\\sydtms01\e$\Translogix\Data\DATA_A','select * from [spjobs.dbf]')
报错
Msg 7357, Level 16, State 2, Line 1
Cannot process the object "select * from [spjobs.dbf]". The OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)" indicates that either the object has no columns or the current user does not have permissions on that object.
求指导，谢谢.
------解决方案--------------------
sql2008好像不支持直接从dbf的导入了，可以先导入sql2000，再导入sql2008试试
------解决方案--------------------
我也遇到同样的问题，哪个高手来解释一手阿阿阿阿