select * from opendatasource('Microsoft.Jet.OLEDB.4.0','Data Source=''d:\Willowbrook.xls'';Extended properties=''Excel 5.0;imex=1''')...[Data$]
转载于:https://www.cnblogs.com/lfzwenzhu/archive/2009/06/03/1495446.html
相关资源:直接使用SQL语句读取Excel表格内容,把表中内容导入数据库中