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)
Encryption and connecting to SQL Server using SSMS
This post is describes connecting to SQL Server 2022 using the SQL Server Management Studio and the encryption of connection. For installin...
-
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...