Export multiple queries into zipped folder

[CraigDolphin]

I am developing a db in three parts: one each to be hosted in two different agencies, and a third to be hosted by a third-party which combines the data from both of the others in one place.

Because there is no common network I need to export data from each of the two agency db's in some form, and then import it into the third db with some import coding to make sure that certain entities are matched up between the two.

There are 5 queries that need to be exported into some format such as csv, or tab delimited. This part is easy enough to do.

However, I would like to take it a step further and have the db create a single export folder to place these 5 files into, and then zip the folder for emailing.

I have searched and googled without much luck trying to figure out a way to do this. I was wondering if anyone might be able to point be in the right direction, or let me know if I'm barking down the wrong rabbit-hole!

Thanks.

 

[DCrake]

Simple Software Solutions

Hi

I have a VB app that does exactly what you want to do. Let me get it together for you and i will give you a link to the download site.

Code Master:

 

[CraigDolphin]

Great. Will look forward to it. Thanks