mutiple html docs into Access

[Red Lorakeet]

Got a mammoth job to do, and I'm not super techy either.

I have hundreds of html documents that contain a single question and answer
on each document.

For example:

Question Will it rain today?

Answer Yes, very probably.

Very simplistic as you can see and the answers are much more detailed than
this but hopefully you get the idea.

What I have to do is create an access database with loads of fields in but
the two most important will be Field A - Question and Field B - Answer.
There will be plenty of other fields as well and I'm hoping that I can just
import these in. My biggest concern is getting all these Questions and
Answers into Access.

I've got Word, Excel and Access to work with.

Anyone any ideas?? please - the simpler the better

 

[Tom Wimpernads]

parse the data.. read it and split it and filter out characters-- whatever
you need to do


and then push it into a database


I mean.. what exactly do you need help with?