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.
| Author |
Topic |
|
batarsehs
Starting Member
9 Posts |
 Posted - 2005-06-20 : 12:24:10
|
| I have the following problem:I have the database on MS SQL database that has a table called "phones", which is the one that needs to be updated with the new phone numbers that I receive from clients every week. The different clients send me the data in different file formats, example, XML, CVS, Excel and Text. as well as different column "field" naming.I have an access database with a table for each client, where i import their files.for now, In order to update the MS SQL phones table, I would need to choose the exact columns that i need from each file, and then insert them into MS SQL. Therefore, i created an excel sheet where i paste all the colums needed from clients files, and then clean the spreadsheet for wrong phone number or null phone fields. Then i need to check that spreadsheet against the "phones" table in the MS SQL database for duplicate phone numbers, delete the duplicates and import the rest of phone numbers into the phones tableI am looking to make this process as automated as possible, especially the step of finding duplicate phone numbers in excel sheet that already exist in the MS SQL "phones" table.Can you help me out, please..... |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
|
|
|
|
|
|
|
check for duplicate records