Problem is solved!
I re-registered the DAO 3.6 dll using the following command:
Regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.DLL"
Then it worked!
See also: http://www.thescripts.com/forum/thread211069.html
I compared the references in the Engelish and Dutch version: both are the same and the references are in the same order (priority). The following references are checked:
Visual Basic For Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft...
I am trying to export data from MS Access (2003) to MS Excel (2003). For some reason this works perfectly in the English version of MS Office 2003, but not in the Dutch version of Office 2003.
I get the following error message when the export routine gets to the CopyFromRecordSet statement...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.