T
tgwarrior
I have over 200 surveys that I've collected via email. The responses are in
the format as shown below -- FIELD_NAME: response.
I would like to import the data into Access2000 (so I don't have to type all
the data in). Is there a way to import this kind of data into Access?
Obviously, I'd like to ONLY import the data after the ":" and make sure that
the data goes into the corresponding field. I also have 200 records, so
would obviously need to make sure that each recordset is imported into a
unique record/recordset. The field types are mainly checkboxes and memos.
Any ideas? Thank you. Type of data is shown 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 MS
the format as shown below -- FIELD_NAME: response.
I would like to import the data into Access2000 (so I don't have to type all
the data in). Is there a way to import this kind of data into Access?
Obviously, I'd like to ONLY import the data after the ":" and make sure that
the data goes into the corresponding field. I also have 200 records, so
would obviously need to make sure that each recordset is imported into a
unique record/recordset. The field types are mainly checkboxes and memos.
Any ideas? Thank you. Type of data is shown 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 MS