您所在位置：主题：导出电子表格问题
wang.hm12104310
[专家分：0] 发布于 2009-04-12 21:58:00
SELECT excel1
DELETE all
PACK
APPEND FROM \nbsch\data\zgjcb
REPLACE ALL 顺序号 WITH xxh,职工编号 WITH zgbh,职工姓名 WITH zgxm
UPDATE excel1 from zgjxhzb SET excel.zgjxhzb(g01,g02,g03,g04,g05,g06,g07,g08,g09,g10,g11,g12,g13,g14,g15,g16,g17,g18,g19,g20,g21,g22,g23,g24,g25,g26,g27,g28,g29,g30,g31,hz,pj)=zgjxhzb where ALLTRIM(excel.zgbh)==ALLTRIM(zgjxhzb.zgbh)
INDEX on xxh TO c:班清班结数据库\xxhsy
COPY TO "c:班清班结数据库\个人得分.xls" TYPE XL5 FIELDS 顺序号,职工编号,职工姓名,g01,g02,g03,g04,g05,g06,g07,g08,g09,g10,g11,g12,g13,g14,g15,g16,g17,g18,g19,g20,g21,g22,g23,g24,g25,g26,g27,g28,g29,g30,g31,hz,pj
导出时出错"SQL找不列"
DELETE all
PACK
APPEND FROM \nbsch\data\zgjcb
REPLACE ALL 顺序号 WITH xxh,职工编号 WITH zgbh,职工姓名 WITH zgxm
UPDATE excel1 from zgjxhzb SET excel.zgjxhzb(g01,g02,g03,g04,g05,g06,g07,g08,g09,g10,g11,g12,g13,g14,g15,g16,g17,g18,g19,g20,g21,g22,g23,g24,g25,g26,g27,g28,g29,g30,g31,hz,pj)=zgjxhzb where ALLTRIM(excel.zgbh)==ALLTRIM(zgjxhzb.zgbh)
INDEX on xxh TO c:班清班结数据库\xxhsy
COPY TO "c:班清班结数据库\个人得分.xls" TYPE XL5 FIELDS 顺序号,职工编号,职工姓名,g01,g02,g03,g04,g05,g06,g07,g08,g09,g10,g11,g12,g13,g14,g15,g16,g17,g18,g19,g20,g21,g22,g23,g24,g25,g26,g27,g28,g29,g30,g31,hz,pj
导出时出错"SQL找不列"
