Recent content by MastaRelaxa

  1. M

    Importing Multiple XML in Access from Folder

    The DBGuy- No it is still working. Now that I am able to successfully get the data into Access, I would like to take it a step further by combining two of the tables together (the goal being to get the patient response data tied to the administrative data of the patient). The problem right now...
  2. M

    Importing Multiple XML in Access from Folder

    NearImpossible- From what I have gathered, using my code to bring in data from these XML files, it appears there could be a total of 4 tables coming out of the XML. Typically it will be 3 tables, but some XMLs will have the additional table if they have stratified sampling (dont worry about...
  3. M

    Importing Multiple XML in Access from Folder

    It worked! I used SXS alteration to the code, adding in the slash after the folder name. Worked flawlessly. I may have more questions around importing XMLs that have two different layouts. One XML would have 3 different tables (Admin Data, Headers, Patient Response), and the other would have the...
  4. M

    Importing Multiple XML in Access from Folder

    Thank you Everyone, for the input! I am going to try and few things, and will let you know what happens!
  5. M

    Importing Multiple XML in Access from Folder

    TheDBGuy - That is a good suggestion, but the files that are in the folder will have been located there for months. Maybe I am totally misunderstanding what you are saying, so please correct me if I am wrong. Thanks!
  6. M

    Importing Multiple XML in Access from Folder

    Even when adding the \ is gives me the same error of not being able to find the File Path: Run-time error '31527': Path not found: C:\Users\pierial\Desktop\XML\ Thanks!
  7. M

    Importing Multiple XML in Access from Folder

    Hello- I have been tasked by my manager to try and create a Macro we can use to pull multiple XML files into Access to review and analyze. All XML Files will have the same headers/tables. I did import the structure of the data from one of the XML files, figuring that all that would need to be...
  8. M

    Hello! New To Access

    Hello- I work in the Healthcare Industry and have been working with data for the past 5 years. As time moves on we have more and more need for VBA macros. I joined this forum to get help with VBA macros and importing data. I am new to Access and have very basic coding knowledge. I appreciate...
Top Bottom