Using Macro to export from Access to excel. Error message

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

William - 27 May 2005 03:46 GMT

I'm trying to export a table in access to excel. I get the error that the
"you tried to use a form,report,or datasheet that contains an OLE object, but
the OLE server(the application used to create the object) may not be
registered properly.Reinstall the OLE server to register it correctly.

I don't know what to do. Should I contact IT to have them reistall the OLE
server or maybe I can do it myself.

Thanks for the help

Reply to this Message

John Nurick - 27 May 2005 06:18 GMT

Hi William,

One of these articles may cover the case.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;302507
http://support.microsoft.com/default.aspx?scid=kb;EN-US;280557
If you have Access 2003, try the solution in the second article.

If this doesn't fix it, post back here.

>I'm trying to export a table in access to excel. I get the error that the
>"you tried to use a form,report,or datasheet that contains an OLE object, but
[quoted text clipped - 5 lines]
>
>Thanks for the help

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

william Bull - 31 May 2005 16:50 GMT

I don't get this message if I try to use tools/ analyze with excel. I only
get it if I try to use the output to macro.

Thanks

Reply to this Message

william Bull - 31 May 2005 16:51 GMT

I forgot to say that I did try this and it didn't change the error.

Thanks

Reply to this Message