Re: [MSAccessProfessionals] Import XML file

yes

i uplaoded 

you can find it here 

https://groups.io/g/MSAccessProfessionals/files/8028195.xml

it is possible open in excel with no problem but not possible import in Access. I'm almost sure that the reason is that is an "attribute"  based XML and I should transform in an ELEMENT based XML, but I do not know how to do. 

thank you 

Il giorno mer 19 lug 2023 alle ore 02:02 Arnelito Puzon <agpuzon@gmail.com> ha scritto:

can you upload a sample xml file so that viewers can see it's structure?

On Sat, Jul 15, 2023 at 5:25 PM avvisati <valentino.avvisati@gmail.com> wrote:

Hello All, 

i need to import one XML file to access, I can open it with no problem in excel and after import but I would like to import directly in Access 

The problem is that when I import using the XML importation of Access, are created some table but empty and I understand  probably the problem is that the file I want to open,  is based on attribute but should be based on element 

I also read that I first should transform the file to a Element based file and after i can import. 

I tried  to creatine xsl file but with no success 

somebody can give me some indication and eventually suggest some tool?

I do not know XML 

thank you 

Valentino 

--

Arnelito G. Puzon

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116413) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_