将.xls文件用制表符分隔形式保存为C:INTERVIEW.txt
建立c:input.ctl如下:
load data
infile 'C:INTERVIEW.txt'
append into table INTERVIEW_TMP
fields terminated by X'09' TRAILING NULLCOLS
(NAME,CELL_PHONE,HOME_PHONE,ADDRESS,BACHELOR)
c:>SQLLDR USERID=OFFICE/OFFICE@QH106 CONTROL=C:INPUT.CTL LOG=C:INTERVIEW.LOG
[@more@]将.xls文件用制表符分隔形式保存为C:INTERVIEW.txt
建立c:input.ctl如下:
load data
infile 'C:INTERVIEW.txt'
append into table INTERVIEW_TMP
fields terminated by X'09' TRAILING NULLCOLS
(NAME,CELL_PHONE,HOME_PHONE,ADDRESS,BACHELOR)
c:>SQLLDR USERID=OFFICE/OFFICE@QH106 CONTROL=C:INPUT.CTL LOG=C:INTERVIEW.LOG
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/271283/viewspace-998395/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/271283/viewspace-998395/