title: Upload Data from Local System Ms Access to Web Sql Server?
body: <p>I have a windows forms application which maintains the billing details of a company's employees. The application stores and manipulates data in an MS Access database. 
  I have to send the data every to the SQL Server Web database so that employees can see their monthly reports on the website.
  My Code is :</p>
  
  <pre><code>Private Sub UploadData()
     Dim conn as New OleDb.OleDbConnection("Connection String Ms Access DB")
     Dim SCON = New SqlConnection(" Web SQL Sever Connection")
          Try
              SCON.Open()
          Catch ex As Exception
              MsgBox(ex.Message)
              Exit Sub
          End Try
     Dim Qcmd As New SqlCommand("select query", SCON)
     Dim Cmd As New OleDbCommand("select id,acc,newacc,city,name,billduedateamt,oldbalance from Records where city = 'Delhi'", conn)
     Dim Mrdr As OleDbDataReader = Cmd.ExecuteReader
          Try
              While Mrdr.Read
                  Qcmd.CommandText = "Insert into billing (acc,newacc,city,name,billduedateamt,oldbalance) Values (" + _
                          Mrdr.Item(0) + "," + Mrdr.Item(1) + ... Up to So On ")"
                  Qcmd.ExecuteNonQuery()
              End While
          Catch ex As Exception
              MsgBox(ex.Message)
          Finally
              If SCON.State &lt;&gt; ConnectionState.Closed Then
                  SCON.Close()
              End If
              conn.Close()
          End Try
  
  End Sub
  </code></pre>
  
  <p>It's too slow, is there any better code to do so?</p>