Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Map Point Live Data Source

Posted on 2013-05-24
5
Medium Priority
?
302 Views
Last Modified: 2013-06-04
HI,

I have a copy of Map Point. I am trying to feed it data from our SQL MS datawarehouse direct, as apposed to the current school boy approach of extracting data into a .csv, and importing this .csv into the map tool, and updating it whenever the data changes.

ps I suspect this question isn't in the correct section, but I wasn't too sure where to place it

Thanks
0
Comment
Question by:BananaFury
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 15

Expert Comment

by:Simon Ball
ID: 39203809
is it this package:

https://www.youtube.com/watch?v=m2oRMGHqe90

It says in the video that it can only import from excel and access db's... doesn't mention ODBC to sql server.

It looks like it could be done by exporting sql data using dts/ssis ( depending on your sql server version) into excel or access format, and having map point connect to that exported file.
0
 

Author Comment

by:BananaFury
ID: 39203985
I have a way around this now, providing MS Access with a view of a live table, and feeding MapPoint with the content of this Access container, but I cannot imagine this is the correct approach to the problem (as suggested by Sudonim I note)

I have been nudged towards using a Mappoint API to drop data straight in from a SQL postcode dump. Does this mean anything to anybody?
0
 
LVL 15

Accepted Solution

by:
Simon Ball earned 1500 total points
ID: 39204873
0

Featured Post

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question