Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Importing xml into Access

Avatar

Not applicable

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?

0 Replies