Hi, I use DTS to transfer data from Excel to SQL table.
There are some ids appear more than one times in the file
but I just want the latest one. How can I eliminate the
previous rows for the same id?
Thanks
Ava

How do you define the latest one? For the transform data
task, you can write a query that just selects the data you
want based upon whatever defines the latest one.

-Sue

On Wed, 5 Nov 2003 07:26:57 -0800, "Ava Meng"
<avameng (AT) yahoo (DOT) com> wrote:

Thanks, Sue,
They just append rows into Excel so the latest one should
be the one with the largest row number for the same id. I
don't know how I can define the condition.
Please help.
Thanks
Ava

I know you can work with importing ranges in a
worksheet...maybe you could work off of that and manage your
imports that way. You can find an example of importing a
named range at:
http://www.sqldts.com/default.aspx?243

-Sue

On Thu, 6 Nov 2003 05:42:53 -0800, "Ava"
<anonymous (AT) discussions (DOT) microsoft.com> wrote: