Re: [MSAccessProfessionals] Import XML file

Hello to all,

I'm trying to open this file and import In access

I can open in Excel but access importation  do not work,

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

 

 

Somebody has some idea how to import this file in Access?

Valentino

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of avvisati via groups.io
Sent: Wednesday, July 26, 2023 7:17 PM
To: MSAccessProfessionals@groups.io
Subject: 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