title: Parsing a web form in to a data table
body: <p>has anyone an idea of how to write a dynamic data parser in VBA to capture data from a text file and input it in to a database table (ms access)? The form has about 55 fields, so I'd rather write a code that is capable of picking up the field name from the text than copying a load of text. Is there a smart way to do this and avoid running a third party app to carry out the task?</p>
  
  <p>The web form (which is output from the Joomla component "PERforms") can also attach an XML file, but this doesn't seem compatible for a straightforward record import in to Access.</p>
  
  <p>The format of the data is as below (I've had to add extra carriage returns in order for it to display across multiple lines.:</p>
  
  <p>Field1 : Test </p>
  
  <p>Field2 : Test 2</p>
  
  <p>Field3 : This is the address</p>
  
  <p>Which is a textarea</p>
  
  <p>on the form</p>
  
  <p>Field4 : Field4</p>
  
  <p>I'm fine getting the data somewhere Access can pick it up from, it's only parsing it that's causing me the problem.</p>
  
  <p>As always, your help is most appreciated.</p>
  
  <p>EDit, as requested :</p>
  
  <pre><code>Role Applied For: Door Supervisor
  Title: Mr
  
  Full Name: John Smith
  
  
  
  SIA DL Badge Number: 01300114000000000
  
  
  
  
  
  
  
  Home Address: Catford Road,Bellingham
  London
  
  Home Postcode: SE1 1SE
  
  Nationality: Nigerian
  
  I certify that I am entitled to work within the United Kingdom: Yes
  
  Term Time Address: Sheep St, Bellingham
  London
  
  Term Time Postcode: se1 1se
  
  
  
  Evening Phone Number: 07222284806
  
  Mobile Number: 07922226206
  
  Email Address: yxs@yahoo.co.uk
  
  Most Recent or Current Employer: Employer.Blah
  </code></pre>