Re: Merging tables when PK values are same for SOME records

genericwmail_at_yahoo.com
Date: 07/08/04 

Date: 8 Jul 2004 08:14:05 -0700

Paul, thanks for the suggestion. I was trying to figure out the UPDATE
syntax late yesterday.

Here's a newb question for you: what do you mean by "create a linked
server to the access database", and how do you do it?

--Whill

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message news:<ujon5gFZEHA.996@TK2MSFTNGP12.phx.gbl>...
> Whill,
>
> replication doesn't really solve this type of issue, at least it wouldn't be
> my first choice of technology. The simplest method is to create a linked
> server to the access database. After that's done, to solve your two issues:
>
> (1) create an update statement which links to the imported excel data:
>
> UPDATE importedExcelTable
> SET Location = AccessLinkedServer...AccessTable
> FROM importedExcelTable, AccessLinkedServer...AccessTable
> WHERE importedExcelTable.lot = AccessLinkedServer...AccessTable.lot
>
> (2) Use a subquery to get new records:
>
> INSERT INTO importedExcelTable(LotNum, Description, Location)
> SELECT (LotNum, Description, Location)
> FROM AccessLinkedServer...AccessTable
> WHERE AccessLinkedServer...AccessTable.lot NOT IN (select lot
> from importedExcelTable)
>
> HTH,
>
> Paul Ibison

Relevant Pages

  • Re: SQLCEReplication over GPRS
    ... Paul T. ... we aren't using an ISA server and unfortunately ... Internet side, just not over GPRS: ... verify that you're telling SQL CE the correct authentication settings ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: using html control to download file from client to server
    ... Paul G ... Software engineer. ... DropDownList has a SelectedValue property. ... On the HTMLInputFile set the runat property to server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Auto reply to DL ( Bharat ? )
    ... Paul ... > published to the Organizational Forms library on Exchange servers), ... >> How exactly do I save the template on the server properly - I created the ...
    (microsoft.public.exchange.admin)
  • Re: Same logonserver even though a few DCs
    ... Thanks Paul. ... If you don't have the tools installed, install them from your server install ... Run dcdiag, netdiag and repadmin in verbose mode. ...
    (microsoft.public.windows.server.active_directory)
  • Re: How TO configure ActiveSync for working via Ehernet(TCP/IP)
    ... Thank Paul G. Tobey ... I had managed to start server with manual! ... Set the Fixed Port option on the TCP/IP Transport ... >> want to spare this serial port for normal use, while use the ethernet ...
    (microsoft.public.windowsce.platbuilder)