excel formatting through access

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

Guest

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
 
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
 
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)
 
Have a good holiday. You might also check out MS Query. Check it out in the
Excel Help file.
Rosco
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

(Access) how to automatically format exported information? 2
Access #Error & Excel Pivot 0
Exporting Query from Access 2007 to Excel 2007 4
controlling excel with access VBA (HELP) 5
Counting multiple memberships 1
Manipulating font and formats in Excel output 2
Excel solver via access/vba 1
Link Access to Excel export back to excel 3

Back
Top