>I am using the following code to work with Excel
>
>oCon = CREATEOBJECT('ADODB.connection')
>oCon.ConnectionString = "Provider=VFPOLEDB;Data Source= "+cDataLoc
>
>One user has an error that says "OLE IDispatch exception code 0 from ADODB.connection: provider cannot be found".
>
>I thought that I need VfpOleDB.dll to use the above code but I do not have thise DLL on my machine and it runs without a problem.
>
>My question is what file I need to check for to make sure that the above connection will succeed?
>
>Thanks

Try Re: ADODB.Connection error? Thread #1187863 Message #1187883