Runtime error 3825 in MS Access
I am trying to merge 5 databases into one. The 5 databases have the same tables , same structure and same field for each tables and the same name for the tables and fields well. Just that the data in each databse is different as it has been taken by 5 different memebrs. So, I am trying to merge all the records into one. So, i am basically trying to write a query for each table and then run a VBA code to run the queries one after the other. The query is `INSERT INTO SoilMeasurementTable IN 'C:\Users\vtalreja\Desktop\Common.accdb'
SELECT *
FROM SoilMeasurementTable;` where Soil measurement is one of tables in the present database and I am copying it over to the same table in a common database.


I have a VBA code for running all the queries one after the other.I have saved this VBA code as a module and running it as a macro in every database so that the records get merged into one databse.So my problem is when it comes to run a particular query for a table it pops out this error " Select * cannot be used in an INSERT INTO query when the sourse or destination table contains a multivalued field." 


I am not sure what it means I have tried to search a lot but with no fortune. Can anyone please please help me out and let me know what is the error likely to be and what could be changed to make it to work.
Runtime error 3825 in MS Access
===

I am trying to merge 5 databases into one. The 5 databases have the same tables , same structure and same field for each tables and the same name for the tables and fields well. Just that the data in each databse is different as it has been taken by 5 different memebrs. So, I am trying to merge all the records into one. So, i am basically trying to write a query for each table and then run a VBA code to run the queries one after the other. The query is `INSERT INTO SoilMeasurementTable IN 'C:\Users\vtalreja\Desktop\Common.accdb'
SELECT *
FROM SoilMeasurementTable;` where Soil measurement is one of tables in the present database and I am copying it over to the same table in a common database.


I have a VBA code for running all the queries one after the other.I have saved this VBA code as a module and running it as a macro in every database so that the records get merged into one databse.So my problem is when it comes to run a particular query for a table it pops out this error " Select * cannot be used in an INSERT INTO query when the sourse or destination table contains a multivalued field." 


I am not sure what it means I have tried to search a lot but with no fortune. Can anyone please please help me out and let me know what is the error likely to be and what could be changed to make it to work.