automatically convert to Excel and CSV and save?

T

tradmusic

Hi,

I am new to macros so please bear with me!

I want to create a function, within access, that will, at a set time of day,
automatically convert the data held in our database to Excel and CSV format,
and save as two seperate files (backup.xls and backup.csv) to an external
location on our PC?

Ideally I'd like this to be a button format that I could include at the foot
of our data entry/edit form?

Is this possible - if so, how?

Thanks in anticipation
Nath.
 

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