Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

Importing xml into Access

Avatar

Former Community Member

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