CopyToRecordSet Question For Xcel '97

[Rogie]

Does the CopyToRecordset Method works in Excel 97? Most of my users are using Excel 97 as of the moment, and creating an Excel workbook that sends statistics of a project to a central Access Database via network. I tried to use the CopyToRecordset method to get the statistics of a project if its statistics have already been sent to the database. I got the error "Class doesn't support Automation". Did I do something wrong?

If not, maybe you could suggest a way for me to check if the statistics of a project have already been written to that database and prompt them if they want to overwrite/update it, using only Excel 97. . . or should I just wait for them to get their new PCs with Windows XP (in 2010)? hehe.

Thanks

 

[Richard Schollar]

Excel 97 does not support the CopyFromRecordset method for ADO connections, but does for DAO connections. Annoying isn't it? I was forced to use DAO when I wanted to link up to an Access database because of this limitation (although I am no longer using Excel97).

Best regards

Richard

 

[Rogie]

So this means I have to learn DAO also? I know its probably here somewhere but can someone point me where can i have a reference for DAO? Also would DAO work for Excel 2000 to 2003? Thanks again

 

[Rogie]

Just found out that DAO is really different from ADO. You're right Parsnip. . . it is annoying. I wish the new PCs come already!