Hi,
Has anyone had much experience of importing XML into Access?
I can see that this would save me a lot of data entry time from sources, but I have some questions. Does it work when the data is stored in mnay tables, connected in an Access query - not just in one table?
What happens to Autonumber ID keys? How does one connect the data to an already existing ID key linked to another table?
Sorry if these questions are not clear - there is not much information out there about importing XML into Access.
Thanks,
Jim
Has anyone had much experience of importing XML into Access?
I can see that this would save me a lot of data entry time from sources, but I have some questions. Does it work when the data is stored in mnay tables, connected in an Access query - not just in one table?
What happens to Autonumber ID keys? How does one connect the data to an already existing ID key linked to another table?
Sorry if these questions are not clear - there is not much information out there about importing XML into Access.
Thanks,
Jim