Application.ImportXML (1 Viewer)

zezo2021

Member
Joined
Mar 25, 2021
Messages
390
friends

a client sent me xml containing a lot of tables

When used this method

Code:
Application.ImportXML

every tag created on a separate table

my question:
when opening access tables after importing form XML not see shared fields between these tables.

is this error

or

Is there something missing in my code above


or there are no relation at all between these tables
 
My guess is Access does not automatically guess and add the table relationships for you. Instead, you have to make that decision to make sure it's the correct one. So, you'll probably have to add them manually.
 
My guess is Access does not automatically guess and add the table relationships for you. Instead, you have to make that decision to make sure it's the correct one. So, you'll probably have to add them manually.

Thank you for your reply

is this method can create relations from XML in the attached image

Application.ImportXML

add a shared field in the tables under company when imported (for example) companyID

because it imports all tables under the company to separate tables with no shared filed (PK) or (FK)
 

Attachments

  • explain.png
    explain.png
    21 KB · Views: 35
My guess is Access does not automatically guess and add the table relationships for you. Instead, you have to make that decision to make sure it's the correct one. So, you'll probably have to add them manually.

do you mean
add PK and FK to table design
And start filling blank rows with FK and PK
 
Thank you for your reply

is this method can create relations from XML in the attached image

Application.ImportXML

add a shared field in the tables under company when imported (for example) companyID

because it imports all tables under the company to separate tables with no shared filed (PK) or (FK)
Can you post a sample valid XML file to import, so we can see the actual results?
 

Users who are viewing this thread

Top Bottom