Diane,
You should take close look at DTS because it's very powerfull and flexibale way to get data in and out SQL Server. A DTS package can be run ouside or inside SQL Server. See
INF: Execute a SQL Server DTS Package from Active Server Pages mskb #
252987 and
HOWTO: Execute a SQL Server 7.0 DTS Package from Visual FoxPro mskb #
247356.
>Hum, I'll have to read more about DTS but I'm not sure it'll do what I want. I'm not exporting the content of one table or portion of it. I have a little script that prepare the data into a temporary table and from there I want to export the results outside of SQL. Ideally I want to be able to call this function from an outside program (actually a .asp page).
>
>Will DTS work? Am I loosing my time trying to learn DTS to do this task? Can a DTS be called outside of SQL? Like, can VFP call a DTS to run? Or maybe a DTS can be call within a store procedure?
>
>Don't need to explain all, just tell me if DTS is the thinkg I should learn.
>
>Actually, I'm looking for a function like the VFP function : "copy to .... type ....". I'm starting to think it won't be that simple!
>
>Thanks.
--sb--