How do I change the import settings in MS Access, so that every XML file added receives a unique identifier?



My problem is that I have multiple XML files, that need to be imported into an Access table. Access reads a single XML file into multiple tables, which isnt a problem yet.


Each XML file has in its filename, xxdssafda.xml, a unique identifier. I want to take this unique identifier in the filename and add it to every entry that is done in the tables and database.


How can I achieve this?


No comments:

Post a Comment