Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    Oakland, CA
    Posts
    126

    Unanswered: Export text field from an Access Report into Excel is strangely formatted

    Hello,
    when I export Access Report (either through the Excel icon or using macro) into Excel some of the values get screwed. To be specific
    0440-006 in Access turns out to be -533100 in Excel after exporting. However 0518-476 is exported correctly.
    You need to know that that field is defined as text in both table and on the report. I cannot reformat it in Excel. Any thoughts are hugely appreciated. Thank you

  2. #2
    Join Date
    Nov 2002
    Location
    Oakland, CA
    Posts
    126
    I found a way around it to export from table/query but it is not an answer for why it gets messed up when exporting from a report

Posting Permissions

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