Append Query

[sokkerkid13]

I am trying to do an append query, but im running into a problem because I have about 100 columns. For some reason there is a field inconsistansy hiding somewhere, is there a quick way to compare the two tables fields, or do i have to go through manually to ensure all fields have the same name/data type?

 

[DCrake]

Go to Database Tools and then Documenter. Then click on the source and target tables and print the reports. Next eyeball the matching fields and check for anomolies.