G
Guest
I have an web app where users need to be able to upload data from a .csv file into a SQL database. What is the best practice for doing this?
My application is a .net web app written in C#, with a SQL Server 2000 database. The web server and database servers are located on different boxes. For security reasons the SQL box does not have FTP or any way for a web user to upload files to it.
From the SQL perspective, it seem like using the bcp Utility or BULK INSERT would be the method of choice, but don't you need to have the data file on the SQL box to do that?
My application is a .net web app written in C#, with a SQL Server 2000 database. The web server and database servers are located on different boxes. For security reasons the SQL box does not have FTP or any way for a web user to upload files to it.
From the SQL perspective, it seem like using the bcp Utility or BULK INSERT would be the method of choice, but don't you need to have the data file on the SQL box to do that?