We receive XML files from a third-party that we import into Access on a daily basis. I created a VB for importing this XML file based on the test form we received. The VB does the following: 1. Converts the attribute-centric XML into element-centric XML using an XSL 2. Imports the converted XML file into Access using ImportXML function. This creates five separate tables "on the fly". 3. Imports data from the five tables into the main table Loans using an append query. 4. Performs file and table cleanup The problem we are now running into is this. The main Loan table and the append query were created based on the the test file and all possible fields. Now that we are receiving real data, not all of the fields are present. When the module is called, we are receiving the "Enter Parameter Value" when importing into the main table Loan for any missing fields. If we enter through these messages, the VB errors with "data type mismatch." I believe the "data type mismatch" error is occuring because there are SQL replace statements in the append query for some of the missing fields. Is it possible to append data using VB instead of using an Access query, doing the following: a. Check if the field exists b. If not, move on to next field c. If so, copy data in that field from one table to another. Thank you in advance.