Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sapator
Constraint Violating Yak Guru
462 Posts |
 Posted - 2014-09-26 : 05:20:58
|
| [code]SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;HDR=YES;Database=C:\z\exceltest.xlsx', 'SELECT * FROM [U_ATNE_05_08_2013$]');[/code]Is it a solution to import another excel sheet or i must do a loop of rowset's?Thanks. |
|
|
|
|
|
Import more than one sheet in excel openrowset