Merging two unlike tables

[vgersghost]

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.

 

[DCrake]

How was this data generated in the first place?

 

[vgersghost]

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.

 

[DCrake]

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

 

[vgersghost]

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.

 

[DCrake]

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

 

[vgersghost]

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