SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    midnight coder
    Join Date
    Dec 2000
    Location
    The flat edge of the world
    Posts
    838
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MS Access doesn't export numbers properly

    I have a MS Access database, and am exporting it to a txt file for import to MySQl.

    One of the number column with auto decimal place holds numbers with 3dp. When I export it, the preview window shows them as 3dp as well, but the actual text file it outputs chops them to 2dp. Why is that and how could I fix it?
    Work smarter, not harder. -Scrooge McDuck

  2. #2
    + platinum's Avatar
    Join Date
    Jun 2001
    Location
    Adelaide, Australia
    Posts
    6,441
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Interesting... I tried it and got the same problem.

    It seems to just be truncating the last number, not even rounding or anything... mmmmm


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •