Problem: How to use the Excel FireDAC Enterprise Connector
– C++Builder 10.3.1
– FireDac Excel Enterprise Connector
– Windows 10
CData is a company that makes drivers for databases. Although this may sound like a useful but prosaic product, CData has a clever twist. Their mantra is “See the world as a database” and their products take this to heart. They allow you to view many things that aren’t databases as if they were. Examples include accessing sites such as eBay, Instagram, Facebook, Twitter and Gmail; working with programs like QuickBooks, Google Sheets, Microsoft Office 365; and manipulating data that is in generic formats, such as JSON, XML and CSV.
Embarcadero teamed up with CData to access the latter’s technology through enterprise connectors. These are versions of CData’s SQL connections that come as Delphi/Builder components. I’ve blogged about the connector for reading CSV files (CSV means comma-separated value) and the connector for accessing GMail . Both of those posts have more background on the general concept of enterprise connectors than you’ll find here. Today’s post is about using an enterprise connector to access Excel spreadsheets, so if you’re interested in that, read on!Continue reading “Using CData’s Excel Connector in C++ Builder”