How can i Import XML data according to params

[NHKRISHNA]

Hi,
I have XML data with attributes like following example

<?xml version="1.0" encoding="UTF-8"?>
<PrintLetterBarcodeData
uid="59456896564" name="Enosh" gender="M"
yob="1992" co="S/O John" house="SPLD-986" street="XXXXX"
loc="X COLONY" vtc="Xvillage" po="P.V.Township" dist="XDist"
state="XSate" pc="568656">

I want to split the data and want get each attribute like name, id, dob etc. How can I do this?
(or) Split/parsing each attribute to a Table....
Plz help.

[Micron]

IMO you would need a complete table of tag words and loop through them. This is just off the top of my head:

For each tag word in the table I'd determine the position in the string where the tag starts. Using that value, I would then start from that position and find the first " and store that value. Then do the same for the next " then use the mid function which can return the value of the word between the quotes. Then do something with the result. Then move to the next table record. Rinse and repeat.

If you Google this, you might find that someone has already written code for it.

[Welshgasman]

Indeed they have?
Just with a quick google https://fmsinc.com/microsoftaccess/m...Read_class.htm

[isladogs]

Have you tried just importing the data into Access from an XML file using the import wizard?

See Import XML Data into an Access Database | Database Solutions for Microsoft Access | databasedev.co.uk

[alansidman]

You may find Power Query helpful in bringing your data into Excel, manipulating it as required and then loading into Access.

Look at this link https://www.myexcelonline.com/blog/i...t-transform-2/