Wednesday, June 17, 2009

Data from MS Excel to SQL Server 2008

Microsoft Excel is a number cruncher par excellence loved by the bean counters (not by Managers though, they love Power point). At times, you may need to take the data on an Excel Spreadsheet to a SQL Server database. This new article I wrote does this for you. The example is trivial but the process is laid out in black and white with screen shots.

If you want to capture tabulated data on the internet and take it into SQL Server or another server, you can run a web query using Excel and transfer it to SQL Server. There are many ways you can play this game.

Check out this article on the DotNetSlacker's web site,

No comments: Protection Status