c++databasec++buildervclxlsb

C++ VCL Interrogating .xlsb Excel database


I need some help for interrogating an xlsb database (file) from a VCL C++ program; (using C++Builder XE2) mainly, i would like to query the data inside for simple viewing (its on the same machine, no networking involved), and i don't need to modify it ! so i would like to know :

  1. Which control to use for connecting to an xlsb database (TDatabase, dbExpress ?)
  2. How to use that control for the purpose of reading the data, (same as SQL?)
  3. The difference between the regular xsl and xslb, and are they used in the same manner ?

I did some research before asking, but the information about that is pretty scarce ! (i'm on Win 7 64bit)

Thank you all !


Solution

  • Never tested it with these files but i believe you can use a TADOConnection and then user Microsoft OLE DB Provider for ODBC Drivers as the data provider, i know it can use access and excel files as a source, personally i have only ever used it for access files, but it might do what you want.