All Forums Connectivity
myokitis 6 posts Joined 03/10
11 Oct 2012
DAO Error When Exporting To MS Access

Whenever I try to export my dataset from SQLA into an MS Access 2007 table I get the following error:
SQLA Version:
System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Access.Dao.Recordset'.

Any ideas how this can be rectified?

MikeDempsey 94 posts Joined 10/06
15 Oct 2012

Versions thru used the Microsoft Office Access Engine dll to support the Export to Access function.
Unfortunately Microsoft designed that dll in such a way that only one version can exist on your system. That means that if you install certain versions of Microsoft Office then that feature will fail.
Because of this we stopped using that dll in and all future releases. We reverted to using Microsoft JET.
If you upgrade to the latest 13.10 release ( or you will be able to export to Access 2003 (*.mdb) files - but not Access 2007 (*.accdb) files. Microsoft Access 2007 and 2010 can however open Access 2003 files.

myokitis 6 posts Joined 03/10
05 Nov 2012

Ahhh.  Thanks for the guidance Mike.

You must sign in to leave a comment.