Kbase P17396: A Decimal data type is imported as a Text data type in MS Access 2000
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
MS Access 2000
Progress 9.1D
SYMPTOM(s):
A Decimal data type is imported as a Text data type in MS Access 2000
CAUSE:
The Progress Decimal data type has a precision of 32 by default. Microsoft Access has a decimal precision limit of 28, so when you import a decimal value with a precision greater than 28 it will import it as a Text data-type.
FIX:
The appropriate precision value has to be defined within Progress SQL-92 during a table creation or within a CONVERT function with the following syntax:
NUMERIC | NUMBER | DECIMAL [ ( precision , scale ) ]
You will then be able to import this field into Microsoft Access 2000 as long as the precision has a value of 28 or lower.