Scheduling an Export file

V

Vic

Hi

Is there anyway you can set up a scheduled export of a
query in Access 02. EG I have a sales query that I want
to export to XML format every day to send to our data
warehouse - I don't want to have to manually run the
export.

Any pointers would be appreciated.
 
G

Guest

-----Original Message-----
Hi

Is there anyway you can set up a scheduled export of a
query in Access 02. EG I have a sales query that I want
to export to XML format every day to send to our data
warehouse - I don't want to have to manually run the
export.

Any pointers would be appreciated.
.
Click to expand...
Have you tried making a macro and run it in the windows
task scheduler
 

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

Images are pixelated when saving to PDF 0
Migrating from 2010 to 2013 - having issues: Exporting to xml 0
How to set a rotating shift schedule for 4 crews with repeat occurrence? -SOLVED 1
VBA - exporting serial letters to single documents 0
Microsoft Project - error opening exported XML file 0
Export to XML - error 31532 0
Problems exporting large query results to text delimited format 2
Display weeks from a Milestone 0

Top