Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Location
    California
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Import text file (2000)

    I have set up specs to import text files into Access. They've always transferred in with no problem. Now the currency field is rounding ($4.18 to $4.20, $2.12 to $2.10, etc) I haven't changed any of the field parameters. Does anyone know how to fix this?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Import text file (2000)

    I'm afraid we'd have to see the text file and the database.

  3. #3
    New Lounger
    Join Date
    Jul 2002
    Location
    California
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import text file (2000)

    Thanks for the offer, unfortunately the file and database contain confidential information. I'll keep trying to figure it out.

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Import text file (2000)

    What is the number of decimal places of the target field (the one in the table)?

  5. #5
    New Lounger
    Join Date
    Jul 2002
    Location
    California
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import text file (2000)

    The text field is 17 spaces with 2 decimals, the specs field length is 19 and the database table is set for currency. I'm trying to get a field definition from our DP center for the file to see if the field length may have been changed and the user's not informed.

  6. #6
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Import text file (2000)

    ... thats interesting as access typically wouldn't round a text field being imported as it would be treated as text unless you are converting it to a number. Are you sure the data isn't being rounded by the other application prior to importing the text field? Are you importing via a direct connection to the other database or ODBC or are you using a text report generated by the other database to import into access? My guess is that the other system is generating a report or dataset that is being imported and the data is rounded prior to being converted to text or you have the database converting the data from text to a number that may be causing the issue. Just my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>
    Regards,

    Gary
    (It's been a while!)

  7. #7
    New Lounger
    Join Date
    Jul 2002
    Location
    California
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import text file (2000)

    Thank you everyone for you help. My DP center has informed me that changes were made to the main frame programs during an upgrade to the software and that is where the problem is. We have it all worked out now.

  8. #8
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Import text file (2000)

    Don't you just hate it when they change something without telling people. They are a pain in the a... when they do that kind of thing.

Posting Permissions

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