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

MS Sql Server LazyDBA home page