• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Using SSIS to export data from a 64 bit server to Excel 2007 (1 Viewer)

Status
Not open for further replies.

Rx_

Nothing In Moderation
Local time
Today, 02:18
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)
 
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom