How to automate running and outputting query results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I create queries for third party vendors that need access to our proprietary
school data. Several of the vendors have asked for the data to be extracted
and exported to them on a regular basis. While I'm not a newbie in Access,
I'm in the swamp when it comes to SQL code and tools that might be used to
export the results directly to an ftp server or an email address.
 
I create queries for third party vendors that need access to our proprietary
school data. Several of the vendors have asked for the data to be extracted
and exported to them on a regular basis. While I'm not a newbie in Access,
I'm in the swamp when it comes to SQL code and tools that might be used to
export the results directly to an ftp server or an email address.
Click to expand...

You can export a query using File... Export; select one of the text options to
export it to comma delimited text files, or whatever they need. No SQL is
needed (beyond what you've already created in creating the query).

John W. Vinson [MVP]
 
I know about exporting the results in various formats. My problems are
twofold: first, automating the query that generates the results and second,
automatically sending the results to an email recipient or ftp site. Thanks
for the quick response.
 
Back
Top