Client wants, Client wants - it's all I ever hear

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Client wants, Client wants - it's all I ever hear

Author

Topic

gfahrlander
Starting Member

23 Posts

Posted - 2003-06-17 : 09:11:21

Client receives XL Spreadsheet with prospective customers.
Client wants to compare XL Spreadsheet to Database and load only new prospects not already in database.
Client wants this all automated.

Anyone ever hear of such a thing

Any ideas how to do this

Client is on something and not sharing with DBA's/application staff

Whatta Bogart

No trees were killed in posting this message. However, a large number of electrons were seriously inconvenienced!

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2003-06-17 : 09:21:28

Shouldn't be too tough. You have a couple of different options. You could just create a job with steps to insert the excel data into a table using OPENQUERY, and then do your processing on that table. Or you could create a DTS package to import the excel data into a table and then do your processing on that table.

Jeff Banschbach, MCDBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources