Exporting result to a folder

[bagia]

Is there a way to create a Macro or Module to
automatically export the results from a Query? I've
created a query based on a table that contains photos of
different regions of the World. Example, I created a
query to pull only photos that pertain to North America.
Now from the result of that query, I want to copy those
pictures to my C drive inside a folder called "Spain". Is
there a way to do this? Any suggestions or ideas would be
greatly appreciated.

Thanks,
Thuha

 

[Ken Snell]

You can export the results of a query by using the TransferSpreadsheet (to
EXCEL) or TransferText (to text file) command. Is that what you seek?