| Import Excel using ODBC importer [message #385903] |
Wed, 11 February 2009 17:03  |
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  |
 |
BlackSwan
Messages: 3227
Registered: January 2009 |
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.
|
|
|
] 
Members
Search
Help
Register
Login
Home
