Importing XML to Access

[Brandy Alexandre]

Okay, I will admit off the bat I'm an Access nitwit and know absolutely
NOTHING about XML. The thing is, I'm an auditor and in my current
project, the vendor I'm auditing for my client allows online access to
the account. It offers the option of downloading billings (HUGE
billings) in either CSV or XML. I looked at the XML and couldn't
figure if I didn't have a browser configured to look at it so I could
copy paste, or if there was something else I could do with it that
would make my task just speed right on by.

Is is possible to import XML into Access or Excel to make it more user-
friendly? My issue is that I only need 7 of the 30+/- columns in the
data. Suggestions appreciated.

 

[Dirk Goldgar]

Okay, I will admit off the bat I'm an Access nitwit and know
absolutely NOTHING about XML. The thing is, I'm an auditor and in my
current project, the vendor I'm auditing for my client allows online
access to the account. It offers the option of downloading billings
(HUGE billings) in either CSV or XML. I looked at the XML and
couldn't figure if I didn't have a browser configured to look at it
so I could copy paste, or if there was something else I could do with
it that would make my task just speed right on by.

Is is possible to import XML into Access or Excel to make it more
user- friendly? My issue is that I only need 7 of the 30+/- columns
in the data. Suggestions appreciated.

Access can import XML; at least, recent versions of Access can. It's
one of the types available when you click File -> Get External Data ->
Import... Access may not handle it wonderfully, but it does work in a
rudimentary fashion.

On the other hand, if I were given a free choice I'd take CSV instead.
The import file is smaller, the import process is quicker, and you can
choose which fields you want to import.

 

[Raghu Prakash]

Hi Brandy,

Including XML in data access pages in Access
In Access, you can include Extensible Markup Language (XML) data in your
data access page in one of three ways. You can link the page to an XML data
file by taking the page offline in Microsoft Internet Explorer; you can set
data access page properties inside Access to allow the page to bind to an
external XML data file; or you can set page properties to embed the XML
data directly inside the page. By using these methods, you can include
read-only data in your data access page.

For Further Information: Including XML in data access pages in Access
http://office.microsoft.com/en-us/assistance/HA010345641033.aspx


Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Brandy Alexandre]

Hi Brandy,

Including XML in data access pages in Access
In Access, you can include Extensible Markup Language (XML) data
in your data access page in one of three ways. You can link the
page to an XML data file by taking the page offline in Microsoft
Internet Explorer; you can set data access page properties inside
Access to allow the page to bind to an external XML data file; or
you can set page properties to embed the XML data directly inside
the page. By using these methods, you can include read-only data
in your data access page.

For Further Information: Including XML in data access pages in
Access
http://office.microsoft.com/en-us/assistance/HA010345641033.aspx


Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers
no rights.

Thanks to both of you. I appreciate the suggestions. Something new to
learn and play with.