Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Auckland, North Island, New Zealand
    Thanked 0 Times in 0 Posts

    Failing to Copy from Access to Excel (xp or 2000)

    I have a 2000 database open in xp. When I copy the results of a query into excel the values are being truncated so that they have no decimal places.


    A query based on a table containing number fields (double) gives a record value of 108.08574085. The display format for the field is set to #,##0, with 2dp so that the number displays as 0.11 (this is correct).
    However if I copy and paste the results from this query into Excel xp the cell value in excel is 0 not 0.11 and is treated as text - so I have to multiply by 1 to change it to a value)

    What am I doing wrong? How can I get Excel to recognise the access data as numeric?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Failing to Copy from Access to Excel (xp or 2000)

    I guess this is because you have specified both the Format and the Decimal Places property. Access handles this, but apparently Excel (or the clipboard) only looks at the Format property. Try setting the Format property to #,##0,.00

Posting Permissions

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