Formatting data while exporting to excel

[Imran Ghani]

Hi! Can someone please guide me about formatting the cells while exporting
data from access to excel, like if we would like outline around the cells,
mention font size and things like that and also how can we send our e.g. sum
columns at the end of our file. Thanks in advance.
Regards,
Imran.

 

[Naz]

Hi Imran

Not sure if this helps. But if you are regularly exporting to the same file.
You may be better of creating a template file in Excel, and usng the Data >
Import External Data > New Database query to pull the table or query
through. You can then format and add sum columns as you need. To refresh the
data you simply right click the data and hit refresh. You can then save under
an appropriate version name every day, week, month etc.

I'd assume if you did it programmatically you would have to create an
instance of excel and manipulate the spreadsheet after you have got the data
across. Doable but beyond me, though i'm sure someone else will know how to
do that.


HTH

____________________
Naz
London
www.LivingWandsworth.co.uk

 

[Imran Ghani]

Hi Naz
Thanks for your helpful notes. But, unfortunatley, being a novice, not able
to comprehend your notes completely. Can you please elaborate it with an
example, so its easy for me to follow.
Regards,
Imran