Appending Data

[kschomer]

I have some small tables (ie Jan, Feb, March etc.)
I want to append all of them into one big table.
From the table tab I do a copy of Jan and try to append Feb. or I do a copy of Jan and using Query tab I do an append query. Either way I am getting an error and cannot get these into one table. I have NO key on the table and all the fields except for one are text fields. Does anyone know WHY this is not working??? Karen

 

[Onyxpurr]

What error are you getting?

All all of your column data types the same in all the tables?