Re: Import and append a column from excel to an existing db

In article <5026DD14-5B76-4554-856E-92618DDBF138@xxxxxxxxxxxxx>, Klatuu <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx> writes
What I meant was to join on the fields that make the record unique so it will
update the correct row.

I would start by using a select query so I could see what is returning, then
once I was getting the correct results, change it to an update query.

Hi Dave

When I run a select query , I can see the two target columns side by side , exactly as I want. Data lined up exactly ready to switch between. This is without joined tables.

Then , when I run the update I get this very long pause and the eventual 'temp file out of space.'

When I do join them , I join the source and destination fields. When I run this , the progress meter runs very fast , but no update is made.

I'll keep playing with it , I'm clearly doing something wrong. I may crack it somehow.

Thanks again. Grateful for any ideas.

I did have a look on the net before , but find the 'solutions' to be far too technical in their language , and assuming of knowledge.
.

Relevant Pages

  • Re: Using IIF statement in query criteria
    ... If there is no F then I need to get the last modified record ... When I run the query the correct row is ... because I have sever non-distinct fields that are in the query. ... thought maybe there was a way to add some logic to the criteria of the ...
    (microsoft.public.access.queries)
  • Re: Using IIF statement in query criteria
    ... I tried creating a query and then sorting by Proj #, ... When I run the query the correct row is ... thought maybe there was a way to add some logic to the criteria of the ... EstNum ProjNum FG_ind O_ind Maint_date Year ...
    (microsoft.public.access.queries)
  • Re: Violation of UNIQUE KEY
    ... >>because, the correct row ... > This requires a slight modification of Adam's query: ... > DELETE Table1 ... > Best, Hugo ...
    (microsoft.public.sqlserver.programming)
  • Printing to thermal printer
    ... I'm assuming because it is coming from a query. ... >try creating a local temp file with the fields for the ... >using the temp file as a record source. ... >>label at a time stopping in between each label. ...
    (microsoft.public.access.reports)
  • how do i expand the file temp dos to run a large query
    ... when i tried to run a rather large query my computer displayed an error ... message after 20 mins that there was "Not enough space on the removeable ... i have got a 300gb hard disk and cannot understand why it's not working i am ... using MS Access 2003 but i think the problem is with the temp file in windows ...
    (microsoft.public.access.queries)