"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:%23V0OIFGtDHA.1996@TK2MSFTNGP09.phx.gbl...
> You have a number of options
>
> I personally though would
>
> Import the spreadsheet into a working table
> Use TSQL UPDATE statements to do the updates against your table
> Clear the Working table
>
> --
> --
>
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
> "J Harrigan" <jlharrigan@hotmail.com> wrote in message
> news:ehTKy6FtDHA.2304@tk2msftngp13.phx.gbl...
> > I'm very new to DTS...this is the 2nd time I've used it. I have an Excel
> > file that I want to use to UPDATE a sql server table. I'm walking
through
> > the DTS Import Data Wizard until I come to Column Mappings. My only
> options
> > are to 1. create a destination table, 2. delete rows in destination
table,
> > or 3. append rows to destination table. I don't want to do any of those.
I
> > just want to update a few of the records. Could 'enable identity insert'
> > help me? Any thoughts on what I need to do differently? Many thanks. Jan
> >
> >
>
>

"J Harrigan" <jlharrigan@hotmail.com> wrote in message
news:ehTKy6FtDHA.2304@tk2msftngp13.phx.gbl...
> I'm very new to DTS...this is the 2nd time I've used it. I have an Excel
> file that I want to use to UPDATE a sql server table. I'm walking through
> the DTS Import Data Wizard until I come to Column Mappings. My only
options
> are to 1. create a destination table, 2. delete rows in destination table,
> or 3. append rows to destination table. I don't want to do any of those. I
> just want to update a few of the records. Could 'enable identity insert'
> help me? Any thoughts on what I need to do differently? Many thanks. Jan
>
>

"J Harrigan" <jlharrigan@hotmail.com> wrote in message
news:OodgrRGtDHA.2224@TK2MSFTNGP09.phx.gbl...
> Thanks Allan. What should the update statement look like? I've done other
> update statements, but only where one table is involved. Also, how do I
> clear the working table, just 'delete from working' when I'm done?
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:%23V0OIFGtDHA.1996@TK2MSFTNGP09.phx.gbl...
> > You have a number of options
> >
> > I personally though would
> >
> > Import the spreadsheet into a working table
> > Use TSQL UPDATE statements to do the updates against your table
> > Clear the Working table
> >
> > --
> > --
> >
> > Allan Mitchell (Microsoft SQL Server MVP)
> > MCSE,MCDBA
> > www.SQLDTS.com
> > I support PASS - the definitive, global community
> > for SQL Server professionals - http://www.sqlpass.org
> >
> > "J Harrigan" <jlharrigan@hotmail.com> wrote in message
> > news:ehTKy6FtDHA.2304@tk2msftngp13.phx.gbl...
> > > I'm very new to DTS...this is the 2nd time I've used it. I have an
Excel
> > > file that I want to use to UPDATE a sql server table. I'm walking
> through
> > > the DTS Import Data Wizard until I come to Column Mappings. My only
> > options
> > > are to 1. create a destination table, 2. delete rows in destination
> table,
> > > or 3. append rows to destination table. I don't want to do any of
those.
> I
> > > just want to update a few of the records. Could 'enable identity
insert'
> > > help me? Any thoughts on what I need to do differently? Many thanks.
Jan
> > >
> > >
> >
> >
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:ubmkB8GtDHA.4056@TK2MSFTNGP11.phx.gbl...
> TRUNCATE the working table is more efficient
>
> UPDATE A
> SET A.Field = B.Field,................
> FROM TableToUpdate A JOIN TableToReferTo B On A.Key = B.Key
>
>
>
> --
> --
>
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
> "J Harrigan" <jlharrigan@hotmail.com> wrote in message
> news:OodgrRGtDHA.2224@TK2MSFTNGP09.phx.gbl...
> > Thanks Allan. What should the update statement look like? I've done
other
> > update statements, but only where one table is involved. Also, how do I
> > clear the working table, just 'delete from working' when I'm done?
> >
> > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> > news:%23V0OIFGtDHA.1996@TK2MSFTNGP09.phx.gbl...
> > > You have a number of options
> > >
> > > I personally though would
> > >
> > > Import the spreadsheet into a working table
> > > Use TSQL UPDATE statements to do the updates against your table
> > > Clear the Working table
> > >
> > > --
> > > --
> > >
> > > Allan Mitchell (Microsoft SQL Server MVP)
> > > MCSE,MCDBA
> > > www.SQLDTS.com
> > > I support PASS - the definitive, global community
> > > for SQL Server professionals - http://www.sqlpass.org
> > >
> > > "J Harrigan" <jlharrigan@hotmail.com> wrote in message
> > > news:ehTKy6FtDHA.2304@tk2msftngp13.phx.gbl...
> > > > I'm very new to DTS...this is the 2nd time I've used it. I have an
> Excel
> > > > file that I want to use to UPDATE a sql server table. I'm walking
> > through
> > > > the DTS Import Data Wizard until I come to Column Mappings. My only
> > > options
> > > > are to 1. create a destination table, 2. delete rows in destination
> > table,
> > > > or 3. append rows to destination table. I don't want to do any of
> those.
> > I
> > > > just want to update a few of the records. Could 'enable identity
> insert'
> > > > help me? Any thoughts on what I need to do differently? Many thanks.
> Jan
> > > >
> > > >
> > >
> > >
> >
> >
>
>