Home » Open Source » Programming Interfaces » Import Excel using ODBC importer (11g)
Import Excel using ODBC importer [message #385903] Wed, 11 February 2009 17:03 Go to next message
barryman9000
Messages: 7
Registered: October 2007
Junior Member
I'm trying to use the ODBC importer to import some excel data. I'm running into a problem with one field that uses both text, and numbers stored as text. The importer just won't import the records that contain something like '10.5.' If I change the field to 10.5M or something like that the importer works.

I've changed my Excel column under format cells - number - and selected text, but that didn't help.

I've also tried using to_char(#) in the importer, under the "Data to Oracle" tab, selected the field and entered the function in the "SQL function" text box.

Any help is appreciated.
Re: Import Excel using ODBC importer [message #385905 is a reply to message #385903] Wed, 11 February 2009 17:15 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please realize that you have an Excel & data problem & not an Oracle problem.

You are paying the price for
> one field that uses both text, and numbers stored as text.
If you fix the data, then no problem exists.

>records that contain something like '10.5.' If I change the field to 10.5M or something like that the importer works.
I do not understand what this means.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you

If we can't reproduce them problem, the odds for a solution are reduced.
Previous Topic: Oracle Lite 10g And C# 2.0
Next Topic: 12154 with Perl Oracle DBD and instant client
Goto Forum:
  


Current Time: Thu Mar 28 13:23:31 CDT 2024