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 |
|
akis3110
Starting Member
3 Posts |
 Posted - 2011-12-25 : 05:23:36
|
| I have a proble with sql server 2008 express R2. I create a Linked derver with Excel 2010. My linked server connection is ok. But when I enable allow inprocess cause I want to use openrow to import data from excel I get this error. Cannot initialize the data source object of OLEDB provider "MICROSOFT ACE.OLEDB.12.0" error 7303Can anyone help me? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-25 : 07:16:37
|
| is it 64 bit or 32 bit server?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
akis3110
Starting Member
3 Posts |
Posted - 2011-12-25 : 12:22:55
|
quote:
Originally posted by visakh16
is it 64 bit or 32 bit server?My server is 32bit also my excel.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-25 : 23:17:10
|
| and i hope its xslx and not excel?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Error when enable allow inprocess