Report to Excell template

[kobooky]

I need first clues on how to make my report export the data to an excell template.
The requested output is numerous excell files (with names defined by the database).
Each Excell file has the same format as the template but with the data from the database.
Please your help.

P.S.
maybe a module or a macro shall do the job?

Thanks in advance.

 

[air0jmb]

I created Excel templates for each report and used the Import External Data tool. It was real easy to set-up using the wizard. Each time I open the template, it automatically refreshes the data. I then click save and it creates the new report file, leaving the template for the next time I want to produce the report. Very easy and has been working with no hitches for several years.

Mike

 

[kobooky]

Thanks air0jmb, but I need something else:
my report shall:
open a template
fill in data
Save-as the excell file
Re-open the templae
fill in other data
Save-as
etc...

Any ideas?

 

[kobooky]

air0jmb,
I understand that you use the excell templates to fill in data into your database.
Am I correct?

 

[air0jmb]

kobooky,

No, my Excel template has only header and column names. When I open it, all the rows from the Access query are displayed in the spreadsheet. Anytime I open the Excel, it is populated with current data from the Access database.

Mike