I'm sorry, but I can't help you with this problem. I have never made ODBC calls to Excel files. You might want to go the one of the Excel NewsGroups on Microsoft's site and search for an existing problem as the one you are having or post a message.

>I have a new problem when I get the data source to work I get an error saying "Could not find installable ISAM". I have searched the web but could not find any thing that would help. I found an artical on the Microsoft Web site that said to check the registry to see the excel dll had the right path and if it did to delete the dll and re-run Office Setup. I did all of this and it still doesn't work right.
>
>
>>>>I have set up an UDL file to link into an Excel file. But after I create the connection and set the provider then call the open function. I get the Error "Data source name not found and no default driver specified". I am new to ADO I think it has something to do with the ODBC.
>>>>
>>>>Thanks in advance