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

  • Thread starter Thread starter neilap
  • Start date Start date
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...
 
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.
 
Back
Top