title: Import txt file from web form to sqlserver database using vbscript
body: <p>I have been asked to build a web application to report on information stored in another system. The other system is locked down but will allow me to export data as a csv file. </p>
  
  <p>I'd like to use an html form on my application so that people (the night shift!) can import data from the other system to my web application. </p>
  
  <p>To allow other people to understand my code I've been using vbscript and trying to use the following pattern in all database operations:</p>
  
  <p>Open Connection
  Build Query
  Execute Query
  Do something with results (if appropriate)
  Close Connection</p>
  
  <p>Is it possible to use this pattern to import a txt file? ie. purely sql based without using store procedures?</p>
  
  <p>Does anyone have a code example? </p>
  
  <p>Hope that makes sense.</p>
  
  <p>Thanks.</p>
  
  <p>Derek</p>