Exporting Access to Excel w/automated formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm a brand new user & have inherited an Access database. I am exporting
some information from Access to Excel & would like to keep the same Excel
format. I guess you would call it automated formatting???

Any suggestions would be greatly appreciated.
 
Not sure what you mean by "keep the same Excel format". Are you using an
existing Excel worksheet to export the data to? Are you trying to make it
look like it would if it were created manually?

Post back some detail, please.
 
I'm trying to help her out with this one and she's out of the office today so
I thought I'd reply. She is using the analyze in excel feature within
Outlook. She'd like to have certain cell names and colors etc in Excel after
importing it from Access without having to change it everytime if that's
possible.

Thanks,
Carla
 
I have never used that feature, so I don't know for sure what the capabilites
are. I do know that exporting from Access, unless you use automation, you
can't maintain formatting. If you use MS Query, I think you can, but I am
not sure.
 
Back
Top