By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,152 Members | 2,193 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,152 IT Pros & Developers. It's quick & easy.

How to upload a text file into SQL Server via ASP.NET?

P: n/a
ABC
Our environment has two servers, one is web and another is SQL Server. I
want a upload page to upload file (which I done.). Then I call "Bulk
Insert" command from ADO.NET, it cannot do that as SQL Server cannot access
the file on Web Server. I made sure the SQL login user have Bulk-insert
rights.
We cannot use BLOB feature as this is not sure my case. Our aim is insert
data which stored on text file into some tables.

Is there any best idea to solve it?
May 12 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
From your Web server you could write the file to a shared folder on the SQL
Server (via mapped drive).

-HTH
"ABC" <ab*@abc.com> wrote in message
news:uP**************@TK2MSFTNGP03.phx.gbl...
Our environment has two servers, one is web and another is SQL Server. I
want a upload page to upload file (which I done.). Then I call "Bulk
Insert" command from ADO.NET, it cannot do that as SQL Server cannot
access the file on Web Server. I made sure the SQL login user have
Bulk-insert rights.
We cannot use BLOB feature as this is not sure my case. Our aim is insert
data which stored on text file into some tables.

Is there any best idea to solve it?

May 12 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.