Jim,

> I'm working on a WinXP system.
>
> I just downloaded and installed the Firebird ODBC driver for Windows,
> version 1.2, dated 8/26/2004.
>
> I used that driver to create an ODBC data source connecting to a
> Firebird/Interbase database used by a data collection system that we
> purchased.
>
> To test this datasource, I used Excel...Import External Data...New data
> query. This presents me with a dialog box from which I am to choose
> tables/fields to include in the query. I am able to connect to the
> datasource, and view the tables. However, when I click on the plus sign to
> expand a table to view its fields, I receive the following error message:
>
> ", Dynamic SQL Error, SQL error code = -206, Column unknown,
> FLD.RDB$FIELD_PRECISION, At line 1, Column 112."

Can you check the ODS version of your database?

And what version of Firebird are you using?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com