Hi everyone.

I could use some help here.
VBA (a little) is the only "program language" I know to use.
However, I must recognize I still have a lot to learn.

I have a bunch of xml files in a directory (ord4527777.xml).
They don´t have a incremental file number but i need to get a field content of each one of them <BuyerOrderNumber>...
Usually, I must open all of them one by one, get the field contend and close the file and go to the next one... half a day
Is there a way i could use access to do this?
Could I read the xml content automatically and put it in a table and go to the next file?
More useful would be a process that could be automatic until get to t he last file...

Thank you very much

Cordeiro

Since it is XML, you could proably run a routine to import the data to a table that matches the schema, then run an Update or Append query to pull the data, then delete the old data.

Failing that, I can give you code to read the xml file line by line until it finds the data you want, and then pull that.

This should be easy to automate since the files will always have the data you want in the same place.

Lemme know.

mmcdonal

Hi mmcdonal,

I kindly would appreciate your offer.
Probably I have not enough VBA experience to understand that code but it will be a reference to go ahead.

Thank you so much,

O. Cordeiro