• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 520
  • Last Modified:

Problems with DECIMALS WHILE IMPORTING ORACLE TABLES

This is the problem:

I need to import Oracle 8.0.5 tables in an Access 2000 database. Some fields in the tables are defined NUMBER 16,8. When I try to import the tables, a message box appears telling me that there is a decimal problems. (If I try to attach the tables, the problem appears too.)

Note: the problem doesn't appear  with Access 1997 and the importation works perfectly.

Could you be of any help?
0
her7
Asked:
her7
  • 3
  • 2
  • 2
  • +4
1 Solution
 
PsychoDazeyCommented:
What number is the error message?
0
 
her7Author Commented:
There is no message number in the dialog box except this information :

"The precision of the decimal field is too small to accept the value you try to add".
Also, there are an OK button and a HELP button, but help is not available.

I try to install Oracle version 8.1.7, but the problem always appears.
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LogicalManCommented:
her7,

  I have found a similar problem when importing currency details from a csv file. My way round this was to link to the import file (table, spreadsheet etc), read the items in as a variant then convert them before writing them to a local table.

HTH

Tony
0
 
her7Author Commented:
LogicalMan ...

Could you be more explicit ... please!
0
 
her7Author Commented:
Also,  when I try to link to the import file, all the fields contain "#ERROR".
0
 
KokaCommented:
I guess it's you ODBC driver problem - try changing it. To my experience, with Oracle 7 I had problems with Oracle diver, while with Oracle 8 with the microsoft one.

If that's one-time task You could also try to import data as string and convert it to numbers in Access (say, create View in oracle with that Number(16,8) field converted to varchar2 and import that view).
Good luck
0
 
hnasrCommented:
Could be a relevant question:
Question: Oracle numeric primary key showing as text in A/97
http://www.experts-exchange.com/jsp/qShow.jsp?ta=msaccess&qid=20153726

This was my comment:
From: hnasr

I am away from my Oracle to try. But I guess the NUMBER(16) format has no Integer equivalent in Access,
and hence it is translated to TEXT field.
---
The problem could be in the accuracy of the linked oracle table fields.
0
 
hotbudareCommented:
Have u tried using the Decimal data type?

HTH/EQTA
T.S.U. Mario Osorio
Punto Fijo, falcon, Venezuela
0
 
NosterdamusCommented:
Hi her7,

Here are links to Oracle ODBC drivers. I suggest that you try to install the latest (for your version) and try again:

1. Oracle ODBC Drivers
http://otn.oracle.com/software/utilities/software_index.htm

2. Oracle Rdb ODBC Drivers
To download these drivers you have to be a member. Membership is free, so you should not have any problem downloading it once you sign up.

Hope this helps,

Nosterdamus
0
 
LogicalManCommented:
Her 7,

  The drivers you want should be in the MDAC 2.5 driver file available from Micrisoft.com - Downloads (Free download).

  Concerning my previous answer regarding importing. I link the external table, leaving all data types of the linked table to default.
I then open a recordset, in code, to this table, and raed in each field as a variant variable type, and then convert this into the correct variable type (e.g. Date/Time, Integer, String, Double, Long, etc, etc), before writing it out to the local table.
 This has two benefits::
1. You keep control over the data being entered into your local table, and
2. You can convert any dubious data types as you wish.

HTH

Tony
0
 
hotbudareCommented:
??
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 3
  • 2
  • 2
  • +4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now