[AccessD] Excel automation issue

Hi John,

I can only answer the MDAC 2.8 issue.  You need to find the 'MDAC 2.8' page
on MS's site.  There are several versions of MDAC 2.8, each for a different
Windows OS.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Skolits
Sent: Tuesday, April 03, 2007 8:36 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Excel automation issue

I have a problem on my PC but it's not occurring on any other PC.

When trying to do a CopyFromRecordset to Excel. I receive the following
error.

"Class does not support automation or does not support expected interface"

The only new thing I have done lately was to install SqlServer 2005 and VB
2005. These were not installed previous to this issue and are not install on
any of my other PCs.

Ms Knowledgebase seems to point to using Access97 with Excel. But I'm
running Access 2000. I have all the latest Service packs.

I have totally removed Office and reinstalled. 

The other odd thing was I found an MDAC that's 2.8 SR1. Thinking it may fix
the problem, I tried to run it and it said "This setup does not support
installing on this operating system"

Anyone run into this yet.

John Skolits