The error means the data source name for the odbc driver you have specified to access Excel is not configured on the system.

I would go into the odbc admin and verify the Data Source is specified in the System DSN tab.

>>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
>
>
>Charles,
>sorry I haven't got an answer, I just thought I'd join the thread as I had the same problem ( I followed JVPS' example in Advisor Mag )
>
>Good Luck
>
>Pete Kane