摘要:
How to Read and Load an Excel 2007 or Excel 2010 File Without Using Import/Export UtilityTo read an Excel 2007 or Excel 2010 file using OPENROWSET, run the following query:SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database=C:\YourFile.xlsx;','SELECT * FROM [ 阅读全文