import from Excel03 to Access03 gives Activex cannot create object

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

karonz - 23 Oct 2007 18:40 GMT

I have a database, and each month have to import from an excel sheet (set up
specifically for the import) into a table in Access. Have had no problems
until this month and now I get "Active X cannot create object" and then the
import cancels out.
Any suggestions?

Reply to this Message

John Nurick - 23 Oct 2007 21:12 GMT

Was Office 2003 Service Pack 3 installed between the last successful
import and the first unsuccessful one?

Can you import data from other Excel workbooks?

>I have a database, and each month have to import from an excel sheet (set up
>specifically for the import) into a table in Access. Have had no problems
>until this month and now I get "Active X cannot create object" and then the
>import cancels out.
>Any suggestions?

--
John Nurick - Access MVP

Reply to this Message

karonz - 29 Oct 2007 21:22 GMT

No, I have not installed SP3. And no I have now found that I cannot do much
of anything. No matter what I try, linked tables, import export, I get the
same error.
ActiveX cannot create component

> Was Office 2003 Service Pack 3 installed between the last successful
> import and the first unsuccessful one?
[quoted text clipped - 8 lines]
> --
> John Nurick - Access MVP

Reply to this Message

karonz - 29 Oct 2007 21:26 GMT

actually the exact error is "ActiveX component cannot create object"
I did a repair on my office...which did not fix it...and I also did an
uninstall and reinstall...which did not fix it.

> No, I have not installed SP3. And no I have now found that I cannot do much
> of anything. No matter what I try, linked tables, import export, I get the
[quoted text clipped - 13 lines]
> > --
> > John Nurick - Access MVP

Reply to this Message

John Nurick - 30 Oct 2007 22:45 GMT

With luck this will help: http://support.microsoft.com/kb/319844/en-us

>actually the exact error is "ActiveX component cannot create object"
>I did a repair on my office...which did not fix it...and I also did an
[quoted text clipped - 17 lines]
>> > --
>> > John Nurick - Access MVP

--
John Nurick - Access MVP

Reply to this Message

karonz - 31 Oct 2007 20:09 GMT

thank you, I had searched for that article, but never found it, must have
been in the wrong MS area.
I had compressed my old files and it compressed the DAO360.dll file. That
was the problem....it is resolved, thank you very much

> With luck this will help: http://support.microsoft.com/kb/319844/en-us
>
[quoted text clipped - 22 lines]
> --
> John Nurick - Access MVP

Reply to this Message

John Nurick - 31 Oct 2007 23:02 GMT

I'm glad that was the answer. It took me a while to find it.

>thank you, I had searched for that article, but never found it, must have
>been in the wrong MS area.
[quoted text clipped - 27 lines]
>> --
>> John Nurick - Access MVP

--
John Nurick - Access MVP

Reply to this Message