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

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
 
K

Ken Snell \(MVP\)

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.
 

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

Excel MS Access 2010- Excel templete autofill from form record 0
Create Invoice in Excel? 2
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
How do I remove background art from a templete I downloaded? 1
How to use excel or access to do the drawing price for customer 1
save workbook created from templete to a specific folder 1
VBAscript for data matching excels 0
How do I add invoice line numbers when importing 6

Top