I am trying to get the data from table A into table AA. Not sure how this works. Tried queries, but no luck. Thanks for any ideas or help.

How was this data generated in the first place?

The date was enter in a maintenance program line by line, not very quickly. I'm tyring to speed up the process. I'm stuck wit the program. Hope this helps.

Is there corrolation between either table and can you map 1 field in one table to another field in the other table?

Not sure what your asking? I could have easily appended the data from table a to table aa if the field names match, but you can see that table a field names end up in one column called field names in table aa and the data is in the next column.

I kinda get the gist of what you mean but what does the A,N,I,D,T columns equeate to? aldo the field names do not match in both tables

Eg: Manufacturer

Not sure what A,N,I,D,T columns are. The field names can be change in either table to match, (copies) and then I could just change them back.
thx