Capturing geo-spatial data from web pages is something that Excel can do very well and processing of geo-spatial data is a new capability that became available in SQL Server 2008 R2. With Bing and Maps new applications are possible.
Getting data from MS Excel to SQL server 2008 R2 is very easy with the Export and Import wizard.
This article shows how you would bring in geo-spatial data from an MS Excel 2010 Spread Sheet file to a database table in SQL Server. As SQL Server 2008 R2 supports geo-spatial data it is very easy to process it on the SQL Server. SQL Server Import and Export Wizard is used.
The SSWUG article can be viewed free by registering as a guest and well sign up as well and get the full benefits.
While you are visiting SSWUG read this other article on Geo-Spatial data :
Subscribe to:
Post Comments (Atom)
SQL Server 2025 ready to go
I have not yet done looking at SQL Server 2022, SQL Server 2025 is ready to go. Microsoft is indeed relentless! Microsoft announced SQL Se...
-
This post provides a tutorial approach to authoring a report with Microsoft PowerBI using data on a SQL Server 2012. PowerBI is Microsof... -
Although some of the new connectors are generally available, some are in BETA. Here is a complete picture of the data connectors available... -
Linked servers offer the following advantages as noted in MSDN documentation: •The ability to access data from outside of SQL Server. •T...
There are many good sql files on my PC now. But yesterday I had an unpleasant problem with theirs. And I couldn't solve my issues for short time. For luck my friend advised me - import batch ms sql. It aided me quite easily.
ReplyDelete