Hello all:
I have an Excel spreadsheet that I have appended to an Access table-let's call it table 1. In table 1, not all of the fields will contain data. This table will then be appended to a larger table in the database-let's call it main table.
Whenever I try to append, via an "INSERT INTO [tablename].... query, the data that I need from table 1 to the main table, I get a validation rule error. I have researched it and I know that it has something to do with how data is entered. Now, I have made sure that all of the fields in table 1 and the main table have the same fields along with their properties. I still don't understand why I am getting this error. Can anyone please offer me some advice as to how to fix the problem or feed back as to why this error exists whenever I try to append the data? Thank you and appreciate all of the help.
RTA
I have an Excel spreadsheet that I have appended to an Access table-let's call it table 1. In table 1, not all of the fields will contain data. This table will then be appended to a larger table in the database-let's call it main table.
Whenever I try to append, via an "INSERT INTO [tablename].... query, the data that I need from table 1 to the main table, I get a validation rule error. I have researched it and I know that it has something to do with how data is entered. Now, I have made sure that all of the fields in table 1 and the main table have the same fields along with their properties. I still don't understand why I am getting this error. Can anyone please offer me some advice as to how to fix the problem or feed back as to why this error exists whenever I try to append the data? Thank you and appreciate all of the help.
RTA