Home » Developer & Programmer » Forms » Import Excel and numbers in varchar field (11g, XP)
Import Excel and numbers in varchar field [message #385902] Wed, 11 February 2009 17:00 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 apprecited.
Re: Import Excel and numbers in varchar field [message #385944 is a reply to message #385902] Wed, 11 February 2009 23:55 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
This is NOT a Forms question. Google 'ODBC Excel'.

David
Previous Topic: populate multiple rows from a table to a multi record block
Next Topic: About creating forms
Goto Forum:
  


Current Time: Mon Dec 05 13:01:51 CST 2016

Total time taken to generate the page: 0.09627 seconds