How do I export data from access into a excel templete (Invoice)

  • Thread starter Thread starter office07idiot
  • Start date Start date
O

office07idiot

I have a invoice templete in excel 2007 that I would like to use with the
infornmation that I have in a access 2007 database. I cant figure out how
exactly to link the two. Can anyone help
 
Unless the template in EXCEL is laid out where the data are to be filled in
as consecutive rows, you'll need to export the data to EXCEL file, and then
either link to that file in your template or use VBA to rewrite the data to
the template.

Or you can use VBA in ACCESS to write the data directly to the template
EXCEL file.

Tell us more information.
 
Back
Top