DAO Error When Exporting To MS Access

Connectivity
Enthusiast

DAO Error When Exporting To MS Access

Whenever I try to export my dataset from SQLA 13.10.0.04 into an MS Access 2007 table I get the following error:

SQLA Version: 13.10.0.4

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?

Thanks.

2 REPLIES
Teradata Employee

Re: DAO Error When Exporting To MS Access

Versions 13.10.0.0 thru 13.10.0.6 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 13.10.0.7 and all future releases. We reverted to using Microsoft JET.

If you upgrade to the latest 13.10 release (13.10.0.9 or 13.11.0.5) 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.

Enthusiast

Re: DAO Error When Exporting To MS Access

Ahhh.  Thanks for the guidance Mike.