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

    Foxpro file import into Access (Access 2003 SP2)

    When i run a select query on a particular foxpro file i get an error saying:

    "The Decimal field's precision is too small to accept the numeric you attempted to add."

    Is there a way around this?

    Can i import into an existing table with a data type of double?

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

    Re: Foxpro file import into Access (Access 2003 SP2)

    It's certainly worth a try. Although the Jet database engine that Access uses formally supports the Decimal data type, the implementation leaves a lot to be desired, so it's best to convert the data to Double (or Currency, if applicable).

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

    Re: Foxpro file import into Access (Access 2003 SP2)

    Thanks Hans, i will try importing it into a double field at work tomorrow.

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

    Re: Foxpro file import into Access (Access 2003 SP2)

    Glad you found it.

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

    Re: Foxpro file import into Access (Access 2003 SP2)

    <P ID="edit" class=small>(Edited by patt on 23-Jan-09 09:04. Show correct amount)</P>IMporting it into a double didn't work.

    I found it was a value of 1.00E+8 in a decimal field in a .dbf file, this being too big for the field and soAccess chucked a wobbly. Changed the amount via Ultraedit and away she flew.

Posting Permissions

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