I'm importing data through the import text wizard. In the windows on the wizard I can see that my numerical data includes 6 decimal places (which I want). When I actually run the wizard, I get only two decimal places in the table I'm creating. I'm importing the numerical data as Double data type. All help is appreciated!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Importing Double data types
- Thread starter thayer
- Start date
Zeroanarchy
Technical User
ok check the table you are importing too. You may find that the field has a Decimal places set to (Auto)or (2) change this to (6) this will make sure the decimals are set correctly on import, now check the display form and make sure the field is set to (6) also other wise it will only display (2).
Hope this helps.
Zeroanarchy
Hope this helps.
Zeroanarchy
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question