need urgent help

I have a query that produce data for contacts, and I need this to end up in
public folders and updates once a day automatically, since it is no direct
access to outlook what I need to do? What kind of code would let me put my
data to public folders?You can use DTS to copy the resultset of a query to a variety of
destinations. Please see the topic, data transformation services in SQL
Server Books Online. The website www.sqldts.com could help as well.
You might also look into alternatives using BCP OUT & other command line
specs like osql which could be helpful in certain circumstances.
Anith|||do you anthing about oledb outlook search?
"Anith Sen" wrote:

> You can use DTS to copy the resultset of a query to a variety of
> destinations. Please see the topic, data transformation services in SQL
> Server Books Online. The website www.sqldts.com could help as well.
> You might also look into alternatives using BCP OUT & other command line
> specs like osql which could be helpful in certain circumstances.
> --
> Anith
>
>