Merge two spreadsheets based on a common column
Posted on 2008-10-15
There has to be a simple way to do this either in Excel or SQL Server 2005.
I have one spreadsheet with customer info including the primary key serv_id, I have another spreadsheet with two columns, serv_id and usage. I want to add the usage to the first spreadsheet based on the serv_id. sql something like this.. update table.usage where table.serv_id = spreadsheet.serv_id.
Eventually I'm going to put this in a sql table, not sure if I should do the merge before I put them in sql server or after.
What's the best way to do this?