Convert text from .html-files to Access-database - oDesk

The job is to convert information in three .html-files to structured information in an access-database (.mdb).

The .html-files contains input from a website-form, and has the following syntax (See attached exampe.htm):



--------------------



<hr><p><b>klasse: </b>1.d

<b>Antal_elever: </b>27

<b>Skole: </b>Allerød Gymnasium

<b>Telefonnummer: </b>20286687

<b>Skole_adresse: </b>Rådhusvej 6

<b>Postnummer_by: </b>3450 Lillerød

<b>Laerernavn: </b>Line Bach

<b>emailadresse: </b>xxxxx@hotmail.com

<b>Date: </b>15-05-2012

<b>Time: </b>13:22:37

</p><h3>Kommentar</h3><p>Pakken skal gerne sendes til:



Laura Jørgensen

Solhøjpark 10

3520 Farum



e-mail: xxxxxx@hotmail.com</p>



--------------------



- and so on. Each .html-file has hundreds of these form postings.



The job is to insert each posting as rows into an access-database, with the following columns (datatype in parenthesis)(See attached exampe.mdb):



Klasse (string - text)

Antal_elever (string - text)

Skole (string - text)

Telefonnummer (string - text)

Skole_adresse (string - text)

Postnummer_by (string - text)

Laerernavn (string - text)

emailadresse (string - text)

Dato (date - e.g.: 15-05-2012 13:22:37)

Kommentar (string - memo)



You receive the .html-files and the access-database, og return the access-database with all the rows from the .html-files.



Starting On: August 3, 2012

Ending On:

Posted On: August 03, 2012 09:14 UTC

ID: 201495966

Category: Software Development > Scripts & Utilities

Skills:

Country: Denmark

Hours Billed: 0.00



click to apply



via All Software Development jobs | oDesk.com https://www.odesk.com/jobs/Convert-text-from-html-files-Access-database_%7E%7E6d0ff9ee15c37dc1?source=rss