Access World Forums

So it matters if this is a one time deal or do you need your DB to do this again. If the former then there are some quick things to do but if this came up again you would have to 'reinvent the wheel'. If you do need to do this repeatedly then it would make sense to dive in and program it properly.

So I'll give the quick and dirty in case that is what you need:

For me, a one time deal is more easily handled in Excel. I am more familiar with it and its simpler.
Export the two tables to Excel (External Data tab). Lemme know if you need detail on that but its pretty straightforward.

Using Excel, join the two tables together. Again I am assuming this is pretty easy using cut and paste techniques. Its very 'manual' but this is a one time process.