Prev: formatting a phone number in a string
Next: how do i fix and type mismatch in expression
From: AccessIlliterate on 5 Apr 2010 12:45
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
From: John W. Vinson on 5 Apr 2010 22:41
On Mon, 5 Apr 2010 09:45:04 -0700, AccessIlliterate
<AccessIlliterate(a)discussions.microsoft.com> wrote:

>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.
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: formatting a phone number in a string
Next: how do i fix and type mismatch in expression