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.
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