Web form data import

[franciscorua]

Hi, all

It is very possible that somebody posted this before, but I cannot find it.

I have a web form using formmail to submit an email to me.

I need to treat the aswers later on, either with access or with excel. But I don´t know how.

I save the email as text file, but it is not tab separated. it is somelike it shown below:

First I need to put the records on rows, right? and then import into excel or access.

Does anyone have any procedure, macro, or similar to perfor this tasks, please?

thank you all in advance!!

Paco
_______________________________________________
11no: checkbox

13no: checkbox

21si: checkbox

22escueta: checkbox

231no: checkbox

232no: checkbox

232no-0: checkbox

234no: checkbox

235si: checkbox

236no: checkbox

237no: checkbox

31si: checkbox

321si: checkbox

322si: checkbox

323si: checkbox

324no: checkbox

325si: checkbox

326no: checkbox

33no: checkbox

33si: checkbox

34no: checkbox

34no2: checkbox

41no: checkbox

42-1semana: checkbox

43-zona: checkbox

441si: checkbox

442si: checkbox

443no: checkbox

45no: checkbox

46no: checkbox

47no: checkbox

48si: checkbox

49si: checkbox

410si: checkbox

411si: checkbox

412no: checkbox

ccaa: Madrid

pais: colombia

enviar: Enviar Formulario

 

[Rich]

http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=236256#post236256

 

[twaccess]

Sorry to bump this thread up, but I was interested in this topic, but each time I click on the threadid link, I seem to go round in circles and never find the actual thread which has all the information.

Please could someone post this link again or at least send me a PM with the information.

Thanks

Terry