I have created a form in LiveCycle that contains a text field where respondents can enter whatever text they want.
The responses are returned to me as XML attached to an email. I’ve got a bit of vba that extracts all the attachments from the emails and puts them in a folder, giving each one a unique title (this just changes the file name but keeps the .xml and has no impact on the content).
I then import the responses into access. Everything is working great until it comes to the comments. At this point the xml schema appears to change and nothing is imported.
Has anyone else had this problem and is there a way of getting access to import the text?