Now here's a bit of a sticky wicket. I installed the new 2013 Access Run Time engine and my OPENROWSET query still wasn't working.
Got to poking around and found that the Microsoft.ACE.OLEDB.12.0 provider is not in my SQL 2008 Providers list but it is in the Providers for SQL 2012 (I have 2 versions of SQL Server co-existing on this machine).
Now I need to figure out how to get it in both places. I'm hoping there's a secret parameter or something on this new Access Engine installer (like /passive as Lowell found), but so far I've had no luck finding it.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St