Re: [MSAccessProfessionals] Import XML file

it is obvious that the xml file is not a well-formed access xml file so it is

not being imported. you need special VBA to create a structure for those

fields in your xml.

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 (#116415) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_