2,723
社区成员
发帖
与我相关
我的任务
分享
Close Databases All
lcExcelFileName=Getfile('Xls', '','', 0, '选择一个Excel表,另存为Dbf表,Excel表的首行内容做为Dbf表的字段名')
If Empty(lcExcelFileName)
Return
Endif
Import From (lcExcelFileName) Type Xl5
lcTmpDbfName=Juststem(Dbf())
For m.lnI=1 To Fcount("&lcTmpDbfName")
lcStr="Alter Table "+ "&lcTmpDbfName Rename Column "+Field(m.lnI)+" To "+Evaluate(Field(m.lnI))
&lcStr.
Endfor
lcPutDbfName=Putfile('',lcTmpDbfName,'Dbf')
If Empty(lcPutDbfName)
Return
Endif
Copy To (lcPutDbfName) For Recno()#1
Close Databases All
my_file=Getfile("xls")
Import From "&my_file" Type Xl5
my_dbf=Strtran("&my_file",".XLS","")
my_dbf=Justfname("&my_dbf")
Select ("&my_dbf")
For m.lnI=1 To Fcount("&my_dbf")
mzd=Substr("ABCDEFGHIJKLMNOPQRSTUVWSYZ",m.lnI,1)
mfilename=Field(mzd)
m_ren="Alter Table "+ "&my_dbf Rename Column "+ mzd+" to "+ Chrtran(&mfilename,Space(1),"")
&m_ren.
Endfor
Go 1
Delete
Pack
Browse