摘要:
SQL Server导入Excel数据SQL读取Excel数据方法:1.使用opendatasourceselect top 10 *from opendatasource( 'microsoft.jet.oledb.12.0', 'data source="D:\list0326111.xls";User ID=admin;Password=;Extended properties=Excel 5.0')...Sheet1$;2.使用openrowsetselect top 10 *from openrowset( 'Microso 阅读全文