Efficiently comparing 2 datasets from different datasources

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Elliot M. Rodriguez (noemail)
Date: 07/06/04 

Date: Tue, 6 Jul 2004 10:38:39 -0400

I can accomplish this relatively easily but inefficiently, and it seems like
a hack, but I cant think of a better workaround. Hopefully someone else here
can.

My task is to perform an update on a dataset retrieved from SQL Server 2000
using a stored procedure. This is the base dataset. Users will send an Excel
document up to a webserver and that excel document, which matches the schema
of the SQL dataset (few differences but nothing major), will be queried
using some inline SQL, and another dataset will be created from this
resultset.

The Excel dataset will contain differences that must be sent up to the SQL
dataset. Once this change is detected in the row, I need to update the
column(s), then once all updates are completed, save the SQL dataset (I dont
care about the Excel dataset; its essentially read only). I can loop through
the Excel dataset and compare column values using Datarows, but there are
upwards of 4000 rows between the 2 datasets, and this usually results in
timeouts.

I found an article that discusses how to do this (cant recall the URL right
now), but it didnt work in my scenario. What are my other options?

Relevant Pages

  • Re: simple query with distinct keyword
    ... it for amost and hour and a half and I cant make it work. ... I am a bit of a newb to SQL, so pardon the 'basicness' of my ... Sux being a total newb. ... I don't care which of the 'dup' records ...
    (comp.databases.ms-access)
  • Re: simple query with distinct keyword
    ... I am a bit of a newb to SQL, so pardon the 'basicness' of my question ... but I still cant seem to get what Im after. ... being a total newb. ... I don't care which of the 'dup' records gets ...
    (comp.databases.ms-access)
  • Re: Update access table to sql table
    ... Probably been answered before however i cant get a specific guide through ... create an update query in access and innerjoin X to Y use its 2 primary keys ... and try to update Field1 from temp table Y it takes about 30mins then bombs ... in sql but i just dont understand why the query cant do it alot quicker.i ...
    (microsoft.public.access.queries)
  • Update access table to sql table
    ... Probably been answered before however i cant get a specific guide through ... create an update query in access and innerjoin X to Y use its 2 primary keys ... and try to update Field1 from temp table Y it takes about 30mins then bombs ... in sql but i just dont understand why the query cant do it alot quicker.i ...
    (microsoft.public.access.queries)
  • Re: Copy between identcal tables
    ... "Alexander Baumgart" wrote in message ... > Sorry i cant reply to the article so i need to reopen a new thread. ... > tables or for archiving records. ... > from a Access DB to a SQL DB;( ...
    (microsoft.public.data.ado)