Adding Excel 9.0 to Project References

[QA1]

Hello,

I am using a Data control in VB 6 to populate a table in Excel. How do I add Excel 9.0 (and/or Access 2000 for that matter)to the project References so that the Connect property of the Data control includes Excel 9.0 in the list?

Thanks,
QA1

 

[hmckillop]

Go to tools, references and selection Microsoft Excel 9.0 Library.
???

 

[CCLINT]

No.

Update to VB6 SP 5 from the MS Site.

Select Excel 8.0 lib in the Connect in order to connect to Excel 9.0, or Access 2000 in order to connect to this.

 

[QA1]

CCLINT,

Thanks for your response. The Access 2000 option was added to the list when I upgraded to SP5.

I am still not able to make Excel work with the Data control. I get an error saying "Couldn't Find Installable ISAM"

Is the ISAM something I can download?

 

[CCLINT]

Remove the REFERENCE to DAO 3.51 and Add a reference to DAO 3.6 (PROJECT|REFERENCES)