insert into ivrgen (mobile) select cast(CAST(mobile as int) as varchar(8)) FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=d:/listMgr/list.xls;Extended Properties=Excel 5.0')...[sheet1$]
注意:Excel格式
mobile
12345678
23456789
.
.
.
insert into ivrgen (mobile) select cast(CAST(mobile as int) as varchar(8)) FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=d:/listMgr/list.xls;Extended Properties=Excel 5.0')...[sheet1$]
注意:Excel格式
mobile
12345678
23456789
.
.
.