Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006

    Unanswered: Formatting an exported Access table in Excel

    Is there an easy way to format my table before I export it to excel? I am trying to avoid running a macro in excel. The format is very simple. I just want to format the column headers, nine at the most. Thanks in advance.

  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    Format the column headers? You mean font, orientation etc and have this reflected in Excel? If so then no - the formatting is specific to Excel. What you call "column headers" I call meta data - it has no "format".

    Anyhoo - good news is it is easy peeps to format Excel from Access - check out the Automate Excel zips in the Code Bank
    pootle flump
    ur codings are working excelent.

Posting Permissions

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