February 1st, 2005, 11:01 PM
Truncation Problems Converting Database
Got an odd thing going on...
Trying to convert an Access database to a text file. However, when this is done, all numbers in the database are truncated down to two decimal places, yet there are some numbers we need to have three decimal places or more. What's causing this is automatic truncation, and is there a way around it?
February 1st, 2005, 11:33 PM
February 2nd, 2005, 12:11 AM
I only skimmed it.... but wtf does that have to do with an Access database?
You need to transfer the table to a text based table within the original database and then export it.... There's another way of doing it in the export by delineating each field's properties but, IIRC, making a new table out of each that have only text fields is probably the quickest.....
Don\'t SYN us.... We\'ll SYN you.....
\"A nation that draws too broad a difference between its scholars and its warriors will have its thinking done by cowards, and its fighting done by fools.\" - Thucydides
February 2nd, 2005, 01:39 AM
I googled " Truncation Problems Converting Database " and that's what came up...
I try to help out as best I can with what little I know...sometimes I get it right and sometimes I don't, and I expect, if I'm wrong, to either be corrected or ignored...which is why I always say " I hope this helps "...either way I'm learning by trying to help others...
I figure if I'm a member of this forum I should at least try to help out. If you check my posts you will see I do this quite often.
February 2nd, 2005, 04:14 AM
Depends how you are exporting the file? How many records etc
straight to .txt???
Try exporting to excel...then formating the cells to the decimal points you need (right click the row or column>format cells>number...set your decimal points)
Hopefully you will see the extra values in the number cells
save as a .csv file (comma deliminated)
close the file...rename it to the .txt format and open.
You should have a comma deliminated text file...with all your decimal points.
.csv files are consider .txt files in Access (versions may very )
Something to try
also you could always try Crystal Reports (my most valuable tool right now)..
hit the database for the fields you want then export again...
hope this makes sense.....my brain is kinda wine infected
How people treat you is their karma- how you react is yours-Wayne Dyer
February 2nd, 2005, 05:09 PM
Heh heh...I'm glad I'm not the only one who was totally lost as to what that link had to with anything...I thought I was just clueless! Thanks for the effort in any case Egal.
I'll try those tips out guys, thanks!
February 2nd, 2005, 07:13 PM
How are you converting the database.
Are you using the export fuction in the menu bar or are you doing it through coding?
What Version of Access are you using.
I found this thread on your problem.
Hope it helps
February 6th, 2005, 05:40 PM
The solution is somewhat "strange", because two things
have been set in relation by Microsoft, which really is not
Either you solve it as morganlefay suggested or
you can do this in "one" exportation-step via ...
changing the regional settings!
By default, access uses the number of digits to export given by the
number default in the regional settings.
Change from 2 (default) to whatever value you need.
ControlPanel -> Regional and Language Options -> Customize -> No of digits after decimal
Sorry for the late reply, but I was on vacation
Hope you can still use it ...
If the only tool you have is a hammer, you tend to see every problem as a nail.
(Abraham Maslow, Psychologist, 1908-70)
February 8th, 2005, 11:57 PM
But it's the thought that counts!
You must spread your AntiPoints around before giving it to sec_ware again.