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

    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
    Location
    One Flump in One Place
    Posts
    14,912
    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
    Testimonial:
    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
  •