Application.ImportXML (1 Viewer)

[zezo2021]

friends

a client sent me xml containing a lot of tables

When used this method

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

 

[theDBguy]

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.

 

[zezo2021]

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)

 

[zezo2021]

?

 

[zezo2021]

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

 

[theDBguy]

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?