CLOSE DATABASES
USE xxhzb IN 0
zap
USE grxx IN 0 ALIAS grxx
Local Axx[RECCOUNT("Grxx")]
Eole=CREATEOBJECT('Excel.Application')
WITH Eole
FOR lnI=1 TO ADIR(Axls,"*.Xls")
.Workbooks.Open(SYS(5)+SYS(2003)+"\"+Axls[lnI,1])
SELECT Grxx
SCAN
DO case
CASE INLIST(ALLTRIM(类型),"C","M")
Axx[RECNO()]=ALLTRIM(.Range(位置).Text)
CASE ALLTRIM(类型)=="D"
Axx[RECNO()]=DTOC(TRANSFORM(.Range(位置).Text,"@R 9999-99-99")) && 不能将EXCEL单元格中的数值导入DBF日期型字段中
CASE ALLTRIM(类型)=="N"
Axx[RECNO()]=Val(.Range(位置).Text)
ENDCASE
ENDSCAN
INSERT INTO xxhzb FROM ARRAY Axx
ENDFOR
.QUIT
ENDWITH
RELEASE Eole
SELECT xxhzb
BROWSE
USE IN xxhzb
SET DATE ANSI
SET MARK TO "-"
SET CENTURY ON
......
......
Axx[RECNO()]=DTOC(TRANSFORM(.Range(位置).Text,"@R 9999-99-99"))
改为
Axx[RECNO()]=CTOD(TRANSFORM(.Range(位置).Text,"@R 9999-99-99"))