I am designing a program in vb6 that is to be linked up to databases in both access and excel. The problem is when I try to link up the database's using the data control I get the following message: "Couldn't find the installable ISAM". I am kinda new to the vb world but I have been told that this is something to do with MDAC.
I have been able to connect to the access database by converting the file to an access 97 format and using the data control, but I still can't find anything to connect with excel.
Can anyone help?