Taking data from access and dumping it into MS MapPoint

Resolved · High Priority · Version 2007

Tue 29 Sep 2009, 12:39 Delegate 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:07 Trainer 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:02 Delegate 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:55 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Related tables

When you have related tables such as Customers and their Orders, the Customer table is the Primary table.

Open the Customers table in datasheet view and go to the Home Tab and Records group. Click on the More option and choose Subdatasheet and then click on Subdatasheet again. Now choose the related table (Orders) and click ok.

Now you can click the + symbol by each company to show the related orders.

View all Access hints and tips