Can someone help me with this?
I am running Access 2003 and attempting to import and append multiple XML files into Access. I currently do this process using the Import tool built into Access’s File menu. The only problem with this is that I have to do one file at a time and I have hundreds of files to import.
I would like to be able to use code to loop through all the files contained within a specified folder and import and append the files into my database.
I am not very familiar with writing code but this does not seem like it should be that difficult to do. If someone could help me with this it would be much appreciated.
Thank You,
rrrelic
I am running Access 2003 and attempting to import and append multiple XML files into Access. I currently do this process using the Import tool built into Access’s File menu. The only problem with this is that I have to do one file at a time and I have hundreds of files to import.
I would like to be able to use code to loop through all the files contained within a specified folder and import and append the files into my database.
I am not very familiar with writing code but this does not seem like it should be that difficult to do. If someone could help me with this it would be much appreciated.
Thank You,
rrrelic
