[Lazarus] ODBC configurations for Excel on Lazarus

2022-03-11 Thread Larry Dalton via lazarus
I’m trying to access an Excel spreadsheet named ‘und30.xlsx’ in a directory ‘c:\inventorydata’ using ODBC Data Source Administrator (64-bit). The DSN is ‘und30’. I am trying to use TODBCConnection named under30conn. How do I configure under30conn? Sent from my iPhone --

Re: [Lazarus] ODBC configurations for Excel on Lazarus

2022-03-11 Thread Michael Van Canneyt via lazarus
On Fri, 11 Mar 2022, Werner Pamler via lazarus wrote: Am 11.03.2022 um 23:03 schrieb Michael Van Canneyt via lazarus: Would it not be easier to use fpspreadsheet ? Accessing excel through odbc seems a rather roundabout way. Yes, definitely

Re: [Lazarus] ODBC configurations for Excel on Lazarus

2022-03-11 Thread Werner Pamler via lazarus
Am 11.03.2022 um 23:03 schrieb Michael Van Canneyt via lazarus: Would it not be easier to use fpspreadsheet ? Accessing excel through odbc seems a rather roundabout way. Yes, definitely (https://wiki.lazarus.freepascal.org/FPSpreadsheet). In the most recent release there is even a

Re: [Lazarus] ODBC configurations for Excel on Lazarus

2022-03-11 Thread Michael Van Canneyt via lazarus
On Fri, 11 Mar 2022, Larry Dalton via lazarus wrote: I’m trying to access an Excel spreadsheet named ‘und30.xlsx’ in a directory ‘c:\inventorydata’ using ODBC Data Source Administrator (64-bit). The DSN is ‘und30’. I am trying to use TODBCConnection named under30conn. How do I configure