Rx_
Nothing In Moderation
- Local time
- Yesterday, 23:34
- Joined
- Oct 22, 2009
- Messages
- 2,803
For those using SQL Server - this is a rare article about exporting Excel with the Microsoft Access Database Engine 2010 Redistributable
The article: listed in the first post, is one of the rare tims the SQL community discuss MSACCESS. It is worth noting if such a task comes your way.
http://www.sqlservercentral.com/Forums/Topic1392242-3288-2.aspx
Sorry to disillusion you, but the 2010 redistributable won't install if you have 64 bit office installed.
What you need is the 32 bit version of the AccessDatabaseEngine from 2007.a bit hard to find, so here is a link to my copy:
https://www.dropbox.com/s/dlp86nd67t33kjn/AccessDatabaseEngine_Office2007_WillRunWith64BitInstalled.exe
And this, as long as you run it *after* running your 64 bit office install, will happily run in parallel.
(Probably not needed for production, but essential for an all-in dev box)
The article: listed in the first post, is one of the rare tims the SQL community discuss MSACCESS. It is worth noting if such a task comes your way.
http://www.sqlservercentral.com/Forums/Topic1392242-3288-2.aspx
Sorry to disillusion you, but the 2010 redistributable won't install if you have 64 bit office installed.
What you need is the 32 bit version of the AccessDatabaseEngine from 2007.a bit hard to find, so here is a link to my copy:
https://www.dropbox.com/s/dlp86nd67t33kjn/AccessDatabaseEngine_Office2007_WillRunWith64BitInstalled.exe
And this, as long as you run it *after* running your 64 bit office install, will happily run in parallel.
(Probably not needed for production, but essential for an all-in dev box)
