January 9, 2013 at 1:31 pm
So we are using the 64 bit version of SQL Server 2008. Form what I have read there is a problem provider "Microsoft.ACE.OLEDB.12.0", but this is the same provider I find when I looked at an SSIS package that was created using the import/export wizard.
I get the error message "The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered." So why does import? export wizard work with this provider but openrowset does not????? It is the same server???
Anyway, still having trouble using getting this to work. I need to use Excel as datasource for my query. Can anyone help me with Openrowset or suggest another method?
Thanks,
Mike
January 9, 2013 at 2:00 pm
I had a similar issue to you i will see if i can find my old post for you, i was using 64 bit PC the problem is if you have a 64 bit Machine with 32 bit office installed, if you uninstall 32 bit office and then install 64 bit office 2010 then this is supposed to rectify the issue but i never managed to get it to work.
EDIT
here you go take a look at this post
http://www.sqlservercentral.com/Forums/Topic1275171-391-1.aspx#bm1281939
***The first step is always the hardest *******
January 9, 2013 at 3:01 pm
Import/Export wizard runs in 32-bit mode if you launch it using SSMS while your server is probably a 64-bit process per the bitness of the SQL Server.
IIRC you can only have one set of the ACE drivers installed at a time and the installer complains at you if it finds the other bitness driver installed.
Microsoft Access Database Engine 2010 Redistributable
You may just have to pick the one you want. A more discerning person might ask "why are you running the Import/Export Wizard on a server anyway" 😉
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply