Re: [Firebird-odbc-devel] ODBC / Excel

[André K. C. <Kna...@be...>]

Yes! Of course you can't trust the consistency of databases which have
non-unique values in primary key fields.

You should fix the cause, not the symptom.




~~~Ihre Nachricht~~~

AvdB> Dear Team,

AvdB> I have a client which is requesting to connect excel via ODBC
AvdB> to Firebird database. So far no problem.
AvdB> I have configured all required DSN and ODBC settings so that
AvdB> connections is established and excel is able to read the database.
AvdB> The only problem which occurs is that some primary key columns
AvdB> have empty cells (not <Null> but simply empty).
AvdB> Excel seems to have a problem in interpreting those and
AvdB> replaces some empty fields with scrap values made out of "neighbors cells".
AvdB> Do you have any idea how to tackle this?

AvdB> General Information:
AvdB> ODBC Driver: Firebird/Interbase driver Version: 2.00.00.148
AvdB> from IBPhoenix Inc (ODBCFB.dll) as of 18.11.2008
AvdB> Dialect: 1

AvdB> Your support is highly appreciated

AvdB> ATB

AvdB> Arie

---