Mindy-
In VB6 and VB.NET I use the shell() function and execute EXCEL directly.
Chris

-----Original Message-----
From: Mindy Riddick
[mailto:mssqldba-ezmlmshield-x29135183.[Email address protected]
Sent: Monday, November 29, 2004 9:29 AM
To: LazyDBA Discussion
Subject: Calling a file from stored procedure

Hi everyone,

I want my users to be able to click on a link on a .asp page and open up
an .xls file that holds data from the database and gets updated each
time the link is clicked on. I created a batch file that opens and runs
the bcp utility, which automatically gets the data each time the
test.bat file is clicked on.

The issue with my solution is that the bcp utility won't run on my web
server without SQL Server on it and for security reasons, I can't
install a desktop version or any version on it. Does anyone have any
suggestions for a workaround?

Thank you.

Mindy


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


--
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.

Douglas County, Oregon
www.co.douglas.or.us


MS Sql Server LazyDBA home page