>>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
If you are useing ADO to connect to Excel to get rid of this problem:
1) Change the provider to "Microsoft Jet 4.0 OLE DB Provider"
2) In the Connection tab put the path to the excel file.
3) In the all tab there is an Extended Properties put in "Excel 8.0" or what ever version of Excel you have.
You can find what your Excel version is by.
oExcel = CreateObject('Excel.Application')
? oExcel.Version()
Charles
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers