Hi Folks
Is there a simple method of importing an XML file into Access so the records are all on one table? I've never tried this before, and when i imported it, it created a table for each field from the XML file. I know i could combine all the records onto one using various queries, but there is a lot of tables generated!!
Any advise would be gratefully appreciated!
Is there a simple method of importing an XML file into Access so the records are all on one table? I've never tried this before, and when i imported it, it created a table for each field from the XML file. I know i could combine all the records onto one using various queries, but there is a lot of tables generated!!
Any advise would be gratefully appreciated!
