Karen

> Thanks for the response :-)
> 
> I wouldn't normally put anything on the sql server, but I have to create a
> networked application in an internet environment.
> 
> Part of the application is the import of a file using an sql BULK INSERT
> with a stored procedure.  The procedure would normally call the file from a
> mapped network drive so there isn't normally an issue.  But to run the
> procedure I need to access the file and the only way I can think to do it is
> to ftp the file to the sql server which I can do no problem from here but
> have no idea how you would go about providing a simple user interface to do
> it.
> 
> If you have any ideas or better suggestions I would love to hear them!

If the Web Server and SQL Server are mutually accessible, could you upload the file to the Web Server and then access it from its UNC path?

Regards

Chris Marsh

"Cthulhu for President. Why vote for a lesser evil?" --Cthulhu.org