excel formatting through access

S

susie

Hi,

I am exporting data to Excel for manipulation from an access query. Is there
any way that I can get the excel file to be automatically formatted for
things such as column width, font type etc.

I have no idea as to how to start doing this so any help would be gratefully
recieved.

Susie
 
R

Rosco

One the best ways I've found is to import your Access data to a " Back End"
table on a 2nd sheet in your workbook.

Set up and format your finished report one the 1st sheet, using cell
linking and look up functions. When ever you rerun your access queries,
import to your "Back end" Excel table, and you should be good to go.

Hope this helps
Rosco
 
S

susie

That sounds like a good idea - I'll try it and get back to you (may be a
while as I am on holiday from work from tomorrow)
 
R

Rosco

Have a good holiday. You might also check out MS Query. Check it out in the
Excel Help file.
Rosco
 
U

Unknown

susie said:
Hi,

I am exporting data to Excel for manipulation from an access query. Is there
any way that I can get the excel file to be automatically formatted for
things such as column width, font type etc.

I have no idea as to how to start doing this so any help would be gratefully
recieved.

Susie
Click to expand...
 
Top