SELECT * into tableName
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test2.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...sheet1$
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test2.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...sheet1$
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test2.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...sheet1$
select top 1 姓名 from
opendatasource('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;IMEX=2;DATABASE=c:\test2.xls'
)...[Sheet1$]取EXCEL中姓名一列的第一笔资料
insert #临时表
SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test2.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...sheet1$
'Data Source="c:\test2.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...sheet1$
这样就会创建一个名字为tablename的table