Sometimes there is a need to import data / geo-spatial data harvested from the web using built-in tools in Excel to SQL Server 2008 R2. The Import and Export Wizard makes it very easy and read up on this article to learn the details on the SSWUG.ORG web site,
http://www.sswug.org/articles/viewarticle.aspx?id=52687
Monday, September 27, 2010
Subscribe to:
Posts (Atom)
Install the latest version of SQL Server Management Studio 20.2
This is the latest version of SQL Server Management Studio [build no:20.2.30.0, released July 9,2024]. Note: it is not an upgrade to SQL Ser...
-
This post provides a tutorial approach to authoring a report with Microsoft PowerBI using data on a SQL Server 2012. PowerBI is Microsof... -
Linked servers offer the following advantages as noted in MSDN documentation: •The ability to access data from outside of SQL Server. •T... -
Although some of the new connectors are generally available, some are in BETA. Here is a complete picture of the data connectors available...