By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,284 Members | 1,697 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,284 IT Pros & Developers. It's quick & easy.

XML to Access?

P: n/a
GM7
All,

I have been given 225 XML files of "questions" and no Schema, and
have been asked to load the data from the XML files into an existing
Access DB.

Each file is essentially 1-n questions and their answers, e.g:

- <Answer name="ClientAddressCityTXT">
<TextValue>Philadelphia</TextValue>

When I import the XML into Access using Get External Data | Import, I
get 3 tables of data - yes/no answers, MC answers, and a blank
Rptvalue table. Interestingly, the TextValue answers don't make it.

Since I "understand" the data in the XML file, I know there's a long
way I can corral the data by bringing it data into Excel, shifting it
around as needed, and then moving it into Access.

But there has to be a faster way...

I've tried a couple of XML tools, but they all ask me for my schema,
which I don't have....

Any suggestions on an easier way to do what I need to do?

Is there a tool to create a schema from an XML file? Would that even
help me?

Thanks,

Patrick

Sep 7 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Rich, Larry, Tom,

Thanks for the advice. No way I can "demand" a schema in this case,
so I will take the "treat it as text" approach and break out the
potato parser.

Thanks again,

Patrick

Sep 10 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.