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.
以上就是Provider selection, when trying to access Excel table in Delphi 7的详细内容，更多请关注web前端其它相关文章！