T
tgwarrior
I have approximately 200 emails that contain survey data in the format of
FIELDNAME: answer.
I'd like to import the surveys from the emails (or .txt files) into
Access2000. Ideally, of course, I'd like to have each email/recordset
entered into its own record and have the field name *not* be imported as part
of the entered text, but rather the data imported into the field name that is
just before the answer. (See data below.)
Is there a way to import this kind of data? Not every survey respondant
answered all the questions, so some surveys have only 10 answers
(fieldname:answer), while others have 90 answers. So, it's obviously
important the the answers are imported into the correct fields in the
database. All emailed surveys are from a webform, so the fieldnames are
consistent throughout all responses.
Ideas? Thank you. Sample data below.
michael munson
(e-mail address removed)
---------------------------------
1a-noaffect: checkbox
2f-committed: checkbox
2g-ltr: checkbox
3a-yes: checkbox
3b-yes: checkbox
3c-no: checkbox
3d-yes: checkbox
3e-yes: checkbox
3f-yes: checkbox
4a-chest: checkbox
5d-front: checkbox
5h-comments: I have HIV
FIELDNAME: answer.
I'd like to import the surveys from the emails (or .txt files) into
Access2000. Ideally, of course, I'd like to have each email/recordset
entered into its own record and have the field name *not* be imported as part
of the entered text, but rather the data imported into the field name that is
just before the answer. (See data below.)
Is there a way to import this kind of data? Not every survey respondant
answered all the questions, so some surveys have only 10 answers
(fieldname:answer), while others have 90 answers. So, it's obviously
important the the answers are imported into the correct fields in the
database. All emailed surveys are from a webform, so the fieldnames are
consistent throughout all responses.
Ideas? Thank you. Sample data below.
michael munson
(e-mail address removed)
---------------------------------
1a-noaffect: checkbox
2f-committed: checkbox
2g-ltr: checkbox
3a-yes: checkbox
3b-yes: checkbox
3c-no: checkbox
3d-yes: checkbox
3e-yes: checkbox
3f-yes: checkbox
4a-chest: checkbox
5d-front: checkbox
5h-comments: I have HIV