[Lazarus] Still trying to connect to Microsoft Excel

[Larry Dalton]

I need help with this EXCEL Error code: "Could not start transaction! ODBC
error details: LastReturnCode:SQL_ERROR;Record 1:SqlStat:HYC00;
NativeError:106;Message:[Microsot][ODBC Excel Driver]Optional feature not
implemented;" I am trying to acces an Excel Workbook from a Lazarus pascal
application using TSQLQuery

I am using Microsoft365 Excel, on a Windows11 os, and Lazarus 3.2. I am
using a TODBCconnection with the following settings:

Name:OdbcConnection1;

Driver: Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, .xlsb)

Params: DBQ=C:\Programs\InventoryData\inventory.xlsm

Connected=true

Transaction= SqlTransaction1

I am connecting this with TSQLQuery with following settings:

AutoCalcFields= true  (I’ve tried both true and false with this one and
doesn’t matter)

Database=ODBCConnection1

ParseSQL=true

SQL=Select * from [Cadillacs$]

Transaction=SQLTransaction1

UsePrimaryKeyAsKey=false (tried both ways)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20240907/41bf6a05/attachment.htm>