The issue with excel not closing correctly when accessed programmatically is one of the most common reasons that I have found that server admins don't want devers to utilise the...

Hi There,

Nice article, I will look at using this in future

previously, I have used the ACE driver to access Excel in the past with pivots to switch the data between...

one other thing that I forgot to mention - you need to install either Excel 2007 on the server that you are executing on or download the AccessDatabaseEngine driver from...

Gaby, Jacob

We have used the ACE provider with Excel 2007 and Excel 2010 Beta files and itworks great with a couple of issues.

1 - no 64 bit as discussed previously...