MapPoint Forums

MapForums

Community of MapPoint and Virtual Earth Users and Developers




Import directly from Sql Server database?

This is a discussion on Import directly from Sql Server database? within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Hello...I just received my trial copy of MapPoint2002. I am trying to integrate mappoint with a vb.net application that is ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Today's Posts Twitter Feed Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read



Click here to register

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 05-29-2003
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
Import directly from Sql Server database?

Hello...I just received my trial copy of MapPoint2002. I am trying to integrate mappoint with a vb.net application that is getting data from a sql server. One of my tables includes zip codes that I would like to map. I see where there are some examples of importing and exporting via an Excel spreadsheet....but I haven't found anything that describes how to import directly from Sql Server. is this even possible? If not...then is the best approach to send my sql server tables to excel and then import that?

thanks,
dw
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 05-29-2003
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 3,041
Blog Entries: 2
Walt Cygan wrote an article on how to access data from SQL Server..:
http://www.mp2kmag.com/articles.asp?...erver.dns-less

The other way to do it is through a Microsoft Data Link or UDL file.. start in the Help File and search for Microsoft Data Link, you can find some more references here: http://www.google.com/search?q=site%...p2kmag.com+udl
__________________
~ Now taking orders for MapPoint 2009 ~
~~
~ Upgrade to MapForums Plus membership ~
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 05-29-2003
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
Thanks for the links to more information!

After I posted last night...and before falling to sleep...I did find something on the UDL solution. I tried it quickly...it seemed to work all right...but I need to experiment with it some more.

Thanks again.
...dw
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
database, directly, import, server, sql


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
Accessing a database directly from MapPoint API nh_capricorn MapPoint 2006/2009 Discussion 1 06-02-2004 06:11 PM
Ability to Import/Link to SQL Server tables and Views... David J Wish List 1 01-26-2004 06:47 AM
Using a DSN-less connection to a SQL Server database to get Anonymous MP2K Magazine Articles 1 01-22-2003 09:55 AM
Import of Database Anonymous MapPoint 2006/2009 Discussion 1 08-26-2002 02:05 PM
Hi All, I want to use data from sql directly on a .... Anonymous MapPoint 2006/2009 Discussion 1 07-09-2002 03:40 AM


All times are GMT -5. The time now is 03:13 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0 RC2
MP2K Magazine
Visitor Map

Menorca Holiday
Enjoy a Menorca holiday at a great rate when booked through UlookUbook!



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59