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 |
|
munkdogg
Yak Posting Veteran
53 Posts |
 Posted - 2007-04-10 : 14:04:02
|
| Hello,I am looking for some "best practice" information on how to properly setup a comparison of SQL data -vs- an Excel spreadsheet. I've never performed this task before, and will likely have to do more in the future. How can I define the range of cells to be used from the xls? There are over 1000 rows in the xls, so a Select * from dbo.table where dbo.column = 'x' just isn't practical.Any information/direction that's out there is most appreciated!Many thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-04-10 : 14:14:37
|
| i'll usually import the spreadsheet to mssql, then can execute regular t-sql against it. |
 |
|
|
|
|
|
Comparing SQL Data against XLS