Excel

I need to expand off this query. Instead of data being imported from cr_stat
ing into cr. I need to import data from excel into cr_staging.
UPDATE cr
SET cr.location = crs.location
FROM cr
JOIN cr_staging crs ON cr.first_name = crs.first_name
AND cr.last_name = crs.last_name
AND cr.ssn = crs.ssn
INSERT cr (first_name,
last_name,
ssn,
location)
SELECT crs.first_name,
crs.last_name,
crs.ssn,
crs.location
FROM cr_staging crs
WHERE NOT EXISTS (SELECT *
FROM cr
WHERE cr.first_name = crs.first_name
AND cr.last_name = crs.last_name
AND cr.ssn = crs.ssn)
THanks,You will either have to create a linked server to the excel spreadsheet OR
use DTS...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Eric" <Eric@.discussions.microsoft.com> wrote in message
news:BED6A03B-B577-49E5-8A90-10E0ECCD236C@.microsoft.com...
> I need to expand off this query. Instead of data being imported from
cr_stating into cr. I need to import data from excel into cr_staging.
> UPDATE cr
> SET cr.location = crs.location
> FROM cr
> JOIN cr_staging crs ON cr.first_name = crs.first_name
> AND cr.last_name = crs.last_name
> AND cr.ssn = crs.ssn
> INSERT cr (first_name,
> last_name,
> ssn,
> location)
> SELECT crs.first_name,
> crs.last_name,
> crs.ssn,
> crs.location
> FROM cr_staging crs
> WHERE NOT EXISTS (SELECT *
> FROM cr
> WHERE cr.first_name = crs.first_name
> AND cr.last_name = crs.last_name
> AND cr.ssn = crs.ssn)
>
> THanks,
>
>