select查询结果存为xls???

[iwantnet]

我用select 语句选择出我要的数据了.我怎么把这个数据保存成xls格式的.
我用prg文件进行的选择,所以最好能直接用命令保存成xls!谢谢

SET TALK OFF
USE d:\svf\14120.dbf EXCLUSIVE
select fzmc,sum(zjfss) as zjfss into table n14120.dbf from d:\svf\14120.dbf group by fzmc
select d:\svf\n14120.dbf copy to 14120.xls type xl5 //报有错误
SET TALK ON

请高手帮我!谢谢

[caixia615]

十豆三大大不是回复过了吗?还没搞定?

[iwantnet]

是呀!因为不能联接回三个贴所以又贴了一个!我这个是就是按他的写的,但是可能我写的有点问题,但是找不到,所以又写了一个!谢谢!
SET TALK OFF
USE d:\svf\14120.dbf EXCLUSIVE
select fzmc,sum(zjfss) as zjfss into table n14120.dbf from d:\svf\14120.dbf group by fzmc
select d:\svf\n14120.dbf copy to 14120.xls type xl5 //报有错误
SET TALK ON

[bigeyescat]

用EXPORT命令可以把表导出XLS文件
SET TALK OFF
USE d:\svf\14120.dbf EXCLUSIVE
select fzmc,sum(zjfss) as zjfss into table n14120.dbf from d:\svf\14120.dbf group by fzmc
use d:\svf\n14120.dbf
EXPORT TO d:\svf\14120.xls XL5
SET TALK ON

[「已注销」]

你看看这个贴子吧。
http://community.csdn.net/Expert/topic/5149/5149862.xml?temp=.4802362

[「已注销」]

http://community.csdn.net/Expert/topic/5149/5149862.xml?temp=.4802362

[honglingwu]

select d:\svf\n14120.dbf copy to 14120.xls type xl5 vfp好像是不支持这种写法的吧.
直接
use d:\svf\n14120.dbf
copy to 14120.xls type xl5
use
或这样用直接用临时表
SET TALK OFF
select fzmc,sum(zjfss) as zjfss into cursor n14120.dbf from d:\svf\14120.dbf group by fzmc
copy to 14120.xls type xl5

[十豆三]

SET TALK OFF
select fzmc,sum(zjfss) as zjfss into table n14120.dbf from d:\svf\14120.dbf group by fzmc
select n14120
copy to 14120.xls type xl5
SET TALK ON

[都市流浪者]

郁闷，居然有人把两个命令当一个命令写？！