Partial Class _Default
    Inherits System.Web.UI.Page
 

    Private Sub Submit1_ServerClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Submit1.ServerClick

        If Not File1.PostedFile Is Nothing And File1.PostedFile.ContentLength > 0 Then
            Dim fn As String = System.IO.Path.GetFileName(File1.PostedFile.FileName)
            Dim SaveLocation As String = Server.MapPath("Data") & "\" & fn
            Try
                File1.PostedFile.SaveAs(SaveLocation)
                Response.Write(<center>Thank you for your submission.</center>)
                Dim connection As String = ConfigurationManager.ConnectionStrings("Dialerresults").ConnectionString
            Catch Exc As Exception
                Response.Write("Error: " & Exc.Message)
            End Try
        Else
            Response.Write(<center>Please select a file to upload.</center>)
        End If

    End Sub

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

    End Sub
End Class

bulk insert dialerresults
from '\\MSBWEB3\data\test.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)

Select * 
from dialerresults
go

quote:

---

Originally posted by dougancil2009

Will the file name always be the same? or be seen? I don't want to create a stored procedure because that's one more point of failure for such a short command. I would much rather have it run from the codebehind. That's kind of how I would prefer to do it. In other words I trust my web server a lot more than I do my sql server to always do what it's supposed to do and it reduces my points of failure by 1.

---