98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Taking data from access and dumping it into MS MapPoint
Taking data from access and dumping it into MS MapPoint
Resolved · High Priority · Version 2007
Tue 29 Sep 2009, 12:39Delegate Lisa said...
Lisa has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Taking data from access and dumping it into MS MapPoint
I have made a Form in Access which holds a list of business locations by address.
I want to find out if there is a way of getting all of this address data from Access and dumping it into MS MapPoint so I can see the data spatially?
I know you can get data from Excel to Map Point, but can't find the way to do it direct from Access?
Is there a way this can be done and if so, what is the process to do this?
Many thanks
Lisa Hadaway
Wed 30 Sep 2009, 15:07Trainer Jacob said...
RE: Taking data from access and dumping it into MS MapPoint
Hi Lisa
Thanks for your post. The short answer is yes you can get your data from Access to be displayed in MapPoint, in fact it is possible to actually have a MapPoint graphic displayed within Access.
How do you do it? You do need to have some knowledge of writing macros and underlying VBA experience. We may be able to assist in a consultative fashion by viewing a sample of your files from both Access and MapPoint and creating a working solution.
This will involve some development time but we will let you know up front what the cost will be so you can decide whether to proceed.
Regards
Jacob
Thu 1 Oct 2009, 13:02Delegate Lisa said...
RE: Taking data from access and dumping it into MS MapPoint
Hi Jacob,
Thank you for your response.
In the team in which I work we have experience of writing macros and some VBA knowledge. Is there any way you could give me the run down of how to do this and I can take it back to my team and we can replicate it?
Kind regards
Lisa
Mon 26 Oct 2009, 14:55Trainer Jacob said...
RE: Taking data from access and dumping it into MS MapPoint
Hi Lisa
Sorry this reponse slipped between the boards, sorry for the delay!
I'm afraid that we would only approach this in a more formal consultative way, and not able to provide an informal work around.
I would advise you have a search around on google, but be careful what you try it is at your own risk!
Regards
Jacob
Mon 2 Nov 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Related tablesWhen you have related tables such as Customers and their Orders, the Customer table is the Primary table. |
