excel 怎么连接firebird数据库

用odbc驱动即可，参考如下
You don't need VBA to do this. Excel has the capacity to draw data from ODBC connections via SQL. If you are using XL2007+ On the Data Tab select "From Other Sources" then choose "From Microsoft Query". Select your ODBC connection to your Firebird database, then construct the query by adding tables/fields/filters etc. One of the last options you are given is to edit the query using MS query editor. Do that if you can't add the right kind of filter or criteria in the previous steps.

Next, choose a range to have the Query Table returned to in your spreadsheet (use a background or new sheet). The Query will remain there once populated, and you can Refresh it to draw any new data.

You can then use an INDEX/MATCH or VLOOKUP Formula in Cell B3 to show the appropriate value from your query.