Creating an Update/Append Query

[Jray9242]

It's been a long time since I worked with Access so I hope I ask my question so all can understand it.

I have an access table looks like this (This is only an example).

Table1: FirstName, LastName, State, Client ID
Table2: Client ID, Phone, Email.



I have a lot of names that have to be added to the table and they are in Excel. If I enter a Client ID for everyone in the Excel, is there a way to import the data to the Access table and have the information put into both tables?

Part 1:

Example: John, Doe, CA, 91001, 555-555-5555, some@no.com

Results:

Table1: John, Doe, CA, 91001
Table2: 91001,555-555-5555, some@no.com

Part 2:

Is to create Update query that would update Table1 from looking at the Excel table or I could import the Excel into Access and do an Update query from the based on the Client ID.

Thanks for the help.

Jim

[recyan]

Part 1:
Example: John, Doe, CA, 91001, 555-555-5555, some@no.com

Results:
Table1: John, Doe, CA, 91001
Table2: 91001,555-555-5555, some@no.com
Jim

Was wondering, whether we could import the full data of the Example in to 2 tables & then delete the unwanted columns from each table.
Thanks

[Jray9242]

Was wondering, whether we could import the full data of the Example in to 2 tables & then delete the unwanted columns from each table.
Thanks

I will have to try that and see what happens.

Thanks