Export Data from an access table to a pre-formatted excel template

N

neilap

Hello,

I've spent hours searching forums for the answer but getting nowhere -
mainly due to my limited knowledge of access!

By using the built in wizard in access I've managed to put a command button
on a form that when pressed, transfers data from one of my access tables into
an excel spreadsheet. This is ok, however, i want to format the layout of
the excel spreadsheet that I've exported tha data to.

From what I've read the best way to do this is to create an excel
spreadsheet template (XLT) (which I can do) and then transfer the access
table data to that template to give me the formatting i want. I just don't
know how to do this? So in summary I want to be able to press a command
button on an access form that will transfer the data from an access table
into a pre-formatted excel template/spreadsheet.

I'd be grateful for any advice on how to do this, bearing in mind my
knowledge of access is fairly basic and revolves around the use of the built
in wizards. I'm not familiar with VBA code writing. Any assistance will be
great...
 
P

Pendragon

do a search on "export to excel" in this forum and in the programming forum
and you will get a good deal of help and ideas.
 

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

Top