>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
Regards,
Peter J. Kane
Pete