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

[Arie v. d. B. <Ar...@it...>]

Dear André,



First of all thanks for your reply.

You are absolutely true. Despite I should have maybe extended my request by the fact that I have three primary key columns which depend on each other. Hence in the sum each line is unique. To underline my problem please consider following example table:



Database:

PrimarKey_1_Name


PrimarKey_2_Object


PrimarKey_3_Typ


Jan1


123/10


A


Jan1





A


Jan1


124/10


A






Excel Outcome:

PrimarKey_1_Name


PrimarKey_2_Object


PrimarKey_3_Typ


Jan1


123/10


A


Jan1


12!?!?!/§%&


A


Jan1


124/10


A








Kind Regards



Arie van den Bos

(Logistics Manager)









Ph.:  +49 2102 99697-18

Fax:  +49 2102 99697-10

www.iteco-supply.com

_______________________________________________________

ITECO Oilfield Supply GmbH

Corresponding Address: An der Pönt 62a, 40885 Ratingen, Germany

Place of Administration: Beethovenstr. 2a, 41462 Neuss

Bart Duijndam - Venue: Neuss, HRB8794



-----Ursprüngliche Nachricht-----
Von: André Knappstein, Controlling [mailto:Kna...@be...]
Gesendet: 28, Apr. 2010 13:36
An: Arie van den Bos
Betreff: Re: [Firebird-odbc-devel] ODBC / Excel



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



---



------------------------------------------------------------------------------

_______________________________________________

Firebird-odbc-devel mailing list

Fir...@li...

https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel