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 |
|
chandrucarrer
Starting Member
1 Post |
 Posted - 2012-01-12 : 01:52:26
|
| Hi,Please help for this topic,im executing this Openrowset t-sql query its excuting continuesly but it wil not shown any result and error messages ..i think some registry value or permission is changed how can i solve this issusselect * from OPENROWSET('MICROSOFT.ACE.OLEDB.12.0','Excel 12.0;HDR=YES;DATABASE=C:\mytest1.xlsx',sheet1$) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-12 : 02:14:52
|
| whats the error you got? also is it 32 bit or 64 bit machine?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2012-01-12 : 03:09:59
|
| The above would work only for the 64 bit machine which has EXCEL 2010 versionMadhivananFailing to plan is Planning to fail |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-12 : 03:19:05
|
quote:
Originally posted by madhivanan
The above would work only for the 64 bit machine which has EXCEL 2010 versionMadhivananFailing to plan is Planning to fail
i think you meant 32 bitACE provider is only available for 32 bit------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2012-01-12 : 03:35:28
|
quote:
Originally posted by visakh16
quote:
Originally posted by madhivanan
The above would work only for the 64 bit machine which has EXCEL 2010 versionMadhivananFailing to plan is Planning to fail
i think you meant 32 bitACE provider is only available for 32 bit------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
Yes You are correct.  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Open rowset