xml import won't work

[Peter Chadbund]

This is the first time I've tried to do this so any help would be much
appreciated.
I created a form as a pdf file, which is accessed from my website. When
someone fills the form in, the data is emailed to me as an xml file.
Initially I filled in a form myself and used that to create an acess
database from Adobe Acrobat, which worked OK. Having received other sets of
form data as xml files, if I try and import them into the database I get a
message that the xml file doesn't exist. Also it tries to import the data to
a new table, but I want to put it into the existing table and can't see how
to do it!
Can anyone please help?
Peter

 

[Jack D. Leach]

This is the first time I've tried to do this so any help would be much
appreciated.
I created a form as a pdf file, which is accessed from my website.
When someone fills the form in, the data is emailed to me as an xml
file. Initially I filled in a form myself and used that to create an
acess database from Adobe Acrobat, which worked OK. Having received
other sets of form data as xml files, if I try and import them into
the database I get a message that the xml file doesn't exist. Also it
tries to import the data to a new table, but I want to put it into the
existing table and can't see how to do it!
Can anyone please help?
Peter

Have you verified the XML data returned by your pdf outside of Access to
make sure all is well? I assume you are attempting to use the import
wizard to do this, but you may also want to check out the
Application.ImportXML method if you would like it to be automated, and
maybe a few more options there.

You may have to resort to pulling this information into a new, temporary
table, then copying the relavent data to it's final home, but I'm not
exactly sure. The ImportXML method doesn't seem to give an option on where
to import (though you can set an acAppendData constant, which presumably
would go to an existing table...)

hth