error with CopyFromRecordset

mccaff
11-19-2003, 04:05 AM
Hi,
Im trying to use the CopyFromRecordset method to copy a recordset into an Excel 97 file but am getting the following error

'class does not support automation or does not support expected interface'


Im using access 97 aswell

Any ideas of how to get over this bug

Regards

Padraig

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum