Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2022-03

ODBC configurations for Excel on Lazarus

6 messages · 3 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Larry Dalton

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

Reply by email

Michael Van Canneyt
to Larry Dalton
Larry Dalton 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 under30conn?

Would it not be easier to use fpspreadsheet ?

Accessing excel through odbc seems a rather roundabout way.

Michael.

Reply by email

Michael Van Canneyt
to Werner Pamler
Werner Pamler wrote 8 lines
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 TsWorksheetDataset which allows to access the spreadsheet in a database way.

Cool, I didn't know that one yet ! :-)

Is there an example for it's use ?
Given the way companies often rape excel sheets,
this component will make life a lot easier for many things :-)

Michael.

Reply by email

Werner Pamler
to Michael Van Canneyt
Michael Van Canneyt wrote 5 lines
Cool, I didn't know that one yet ! :-) Is there an example for it's use ? Given the way companies often rape excel sheets, this component will make life a lot easier for many things :-)

There are two examples in folder examples/dataset of the fpspreadsheet installation. Note that it was not intended to carry database technology into the main laz_fpspreadsheet package, therefore, the dataset was put into a separate package, laz_fpspreadsheet_dataset, which must be installed to test the two demo projects.

Reply by email

Michael Van Canneyt
to Werner Pamler
Werner Pamler wrote 10 lines
Am 11.03.2022 um 23:43 schrieb Michael Van Canneyt via lazarus: > Cool, I didn't know that one yet ! :-) > > Is there an example for it's use ? Given the way companies often rape excel > sheets, this component will make life a lot easier for many things :-) There are two examples in folder examples/dataset of the fpspreadsheet installation. Note that it was not intended to carry database technology into the main laz_fpspreadsheet package, therefore, the dataset was put into a separate package, laz_fpspreadsheet_dataset, which must be installed to test the two demo projects.

Thanks. I had a look, this looks good indeed !

Michael.

Reply by email