Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Nov 2003
    Location
    Iowa, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    export from Access to Excel (2003)

    We have an Access database with lots of queries that are exported periodically to Excel. They work fine because they are just straight text fields that don't have any real formatting issues. However we have a new field to be added to one query in Access that is a Yes/No checkbox. When it exports to Excel, the column is True/False. Is there a way to format this field/column in Excel to be a checkbox, or at the least Yes/No rather than True/False? Access is 2002 and Excel is 2003.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: export from Access to Excel (2003)

    I think it would be easier to change your query to use:
    <code>iif([FieldName],"Yes","No")</code>
    instead.
    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    New Lounger
    Join Date
    Nov 2003
    Location
    Iowa, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: export from Access to Excel (2003)

    Works great...

    Thanks for the assist!

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: export from Access to Excel (2003)

    Glad to help!
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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