merging tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kevcar40 - 29 Dec 2005 13:20 GMT

Hi

I am importing two excel spreadsheets into access table 1 and table 2,
the two spreadsheets have the same fields, i would like to join or
merge these tables giving table 3 so a user can write to the table via
a form,

I have joined the tables together and linked a form to the result but
i can not write in any of the text boxes
this is the reason i wish to merge the tables

can anyone tell how to do this as import the spreadsheets or straight
after the tables have be updated

thanks

kevi

Reply to this Message

BB - 29 Dec 2005 15:32 GMT

If I understand your question correctly, try this:

1. Create a Make Table query based on table 1. When you run it, it
will create the third table with the same structure as table 1 and fill
it with all of table 1's data.

2. Create an Append query based on table 2. Make it append its data
to table 3.

3. Change your form to use table 3 as its RecordSource.

Now, the better question may be why it won't let you edit the data. It
may be that your join is incorrect. If you post the SQL here, we may
be able to figure it out.

Cheers,
Bill

Reply to this Message