Excel 数据导入SQL server 2000 示例

insert into Pub_Mail (workno,name,mail)
select 工号,[姓  名],邮箱地址 
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
  'Data Source="c:\邮箱联络表.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...sheet1$ a