http://sqlblog.com/blogs/linchi_shea/archive/2007/03/06/a-little-scripting-saves-the-day.aspxRecently, I got sucked into importing Excel sheets into a database. I had thought, well that's easy with a tool such as SQL Server 2000 DTS Import/Export Wizard or SQL Server 2005 Import/Export Wizard. Needless to say, the Excel import business ran intoenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/linchi_shea/archive/2007/03/06/a-little-scripting-saves-the-day.aspx#955Thu, 08 Mar 2007 22:23:12 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:955Stephen Moore<p>The approach that I've always used for this is to create an Excel formula that builds an INSERT statement based off of the data in the spreadsheet. &nbsp;Then just copy the formula results to the clipboard and paste them into SSMS or Query Analyzer and run them. &nbsp;It sometimes takes a few iterations to make sure I have the formula bugs worked out, but it's the quick and dirty preference for me.</p> http://sqlblog.com/blogs/linchi_shea/archive/2007/03/06/a-little-scripting-saves-the-day.aspx#957Fri, 09 Mar 2007 13:55:12 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:957Linchi Shea<p>Interesting! Does this work well with arbitrarily long cell contents for a text colum? I'm no Excel expert, but I guess you could use Excel formula to easily find the lengths of all the cells, right?</p> http://sqlblog.com/blogs/linchi_shea/archive/2007/03/06/a-little-scripting-saves-the-day.aspx#1146Mon, 16 Apr 2007 15:24:17 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:1146Ranga <p>I have used linked server to query excel sheets.....it works!</p>