Export table to MAccess from SQL Store Procedure

Hi people.

I need some help to export a table to Microsoft Access using a Store Procedure.

My Store Procedure will pupolate a temporary table with some information. After that I want that the store procedure export this table to Access.

Is there any script or command that can do it? And how can i use it into a Store Procedure?

Please, if possible give a example.

thanks in advance
:confused:DTS (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/dts_overview.asp) is almost certainly what you want.

-PatP|||How can i do it?? can you give a example??|||Follow the link I provided. There are several hundered examples provided there!

-PatP