ODBC Importer appending ".0" to id numbers from Excel

[dgrieb]

When importing from an Excel source using PL/SQL Developer's ODBC Importer utility, a ".0" is appended to all of my id numbers. I've tried defining the ODBC source for various Excel versions and I've tried defining the ID_NUMBER column as various Excel cell types, i.e., Text, Number, General.

Has anyone else run into this and found a work-around?

 

[Marco van der Linden]

I've run into this a couple of times as well. I know sometimes I've managed to get rid of the '.0', but I can't remember how :-(

 

[Marco Kalter]

This should be fixed in 7.0.1.

 

[dgrieb]

I've just installed 7.0.1.1066. The problem remains unfixed.

 

[Marco Kalter]

The .0 only appears in the preview, where all data is converted to text. When the data is passed from ODBC to Oracle, the actual datatype is used, and formatting issues no longer apply.