How to update data in a query

[AccessIlliterate]

One part of my database is used to keep track of contacts within clients. I
created a query using a table and a crosstab query and exported it to excel.
I had staff in my office update the contact information.

Now I want to update the query with the new information from the excel
spreadsheet. The spreadsheet includes updates to existing data and new
record.

How can I do this? It does not look like an update or apend query are what
I am looking for.

Thanks
Brian

 

[John W. Vinson]

One part of my database is used to keep track of contacts within clients. I
created a query using a table and a crosstab query and exported it to excel.
I had staff in my office update the contact information.

Now I want to update the query with the new information from the excel
spreadsheet. The spreadsheet includes updates to existing data and new
record.

How can I do this? It does not look like an update or apend query are what
I am looking for.

Thanks
Brian

It's hard to say, because you haven't given us any information about how your
tables are structured or what the user is updating. It is certain, however,
that a Crosstab query will not be editable; it summarizes the data and
presents the summary. You'll have to have some way to tease out the underlying
unsummarized values.

If you're correcting contact information for existing records, I'd expect that
an Update query should work, but you'll have to tell us more about your tables
(primary key? what's exported and what's not? how can you link the data in the
Excel spreadsheet to the correct record in the table?) to say how.