各位老大大姐大好啊怎么把一个表导入一个DBF文件啊?谢谢

[djjtc2008]

CREATE PROCEDURE p_dfdc(@year1 char(4),@month1 char(2),@year2 char(4),@month2 char(2))
as
declare @list char(500)

select year,month,name,qj_id,right(trans_id,4) as xh,trans_id,(select name from cb_code_bdz where code=left(trans_id,4)) as bdz,left(trans_id,4) as bdbh,(select name from cb_code_xc where code=xc_id) as xc,xc_id,(select ltrim(cont) from cb_code where owner='01' AND std_user='用户代码' and name='用电性质' and left(value,2)=dlxz) as dlxz,p_total,fee_total,(1000*(fee_total/p_total)) as qddj,address,(select max(qj_id) from cb_watt where user_id=v_ddjl_df.qj_id) as bh into #temp_dfdl from v_ddjl_df where year>=@year1 and year<=@year2 and month>=@month1 and month<=@month2 order by year,month

insert into openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\df','select * from [dfdc.DBF]')select * from #temp_dfdl



GO
接行时怎么说我不正确啊
错误是:


（所影响的行数为 198255 行）

服务器: 消息 7399，级别 16，状态 1，过程 p_dfdc1，行 7
OLE DB 提供程序 'MSDASQL' 报错。提供程序报告了意外的灾难性错误。
[OLE/DB provider returned message: 不能更新查询，因为 FROM 子句不是单一的简单表名。]

[新鲜鱼排]

没有用过，搜搜
insert into openrowset(’MSDASQL’,
’Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:’,
’select * from [aa.DBF]’)
select * from 表

说明:

SourceDB=c: 指定foxpro表所在的文件夹
aa.DBF 指定foxpro表的文件名.