I am trying to connect to excel table from Delphi 7 using TAdoConnection component. The problem is when I select Microsoft.Jet.OLEDB.4.0, Extended Properties="Excel 8.0;", I sometimes receive error, > that external table is not in the > expected format. When i select: Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=Excel 12.0; then some users receive following error: > "Provider cannot be found. It may not > be properly installed". Is there a way to solve my problem?
Interesting that in both cases, it is the client who receives this error, not me. Bot ways work for me, for the same excel file, which is used by the client.