Microsoft KB Archive/141295

= ACC: Data Used for Data Map Must Match Predefined Format =

Article ID: 141295

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q141295



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
When you use the Microsoft Map feature in Microsoft Access 97 or the Data Map feature in Microsoft Access 7.0 to create a map, you may receive one of the following error messages:

In Microsoft Access 97 using Microsoft Excel 97:

The following data from your worksheet is not recognized as geographic data.

In Microsoft Access version 7.0 using Microsoft Excel 7.0:

The Data Map requires you use one of the sample templates for your data format.



CAUSE
Your data source does not match one of the predefined formats in the Mapstats.xls template.



RESOLUTION
Make sure your data matches the data in the sample template Mapstats.xls. The file is located in the following folder:

  C:\Program Files\Common Files\ Microsoft Shared\Datamap\Data



STATUS
This behavior is by design.



MORE INFORMATION
Microsoft Excel 7.0 and 97 include a mapping feature that you can use to create a map based on data that you have stored in a spreadsheet or table. The mapping feature is called Microsoft Map (Datamap in Microsoft Excel 7.0) and is made available by an add-in that you load in Microsoft Excel. After it's loaded, the feature is available to you by clicking Object on the Insert menu.

In Microsoft Access 7.0 and 97, you can create a map from existing data that resides in a table or query. However, the data must match one of the predefined formats in the Mapstats.xls template.

Steps to Reproduce Behavior
 Open a database in Microsoft Access 7.0 or 97. Create a new form in Design view. Click Object on the Insert menu. In the Insert Object dialog box, under Object Type, click to select Microsoft Map (Data Map in Microsoft Access version 7.0), and then click OK.

NOTE: If the Microsoft Map does not appear in the list box, install it by running setup for Microsoft Excel 7.0 or 97 and adding the map feature.</li> To create a map, click External Data on the Insert menu.</li> Click to select Microsoft Access, and then click OK.</li> In the Open Database dialog box, click Northwind.mdb.</li> Click the Orders table, click the arrow button to add the CustomerId and ShipCountry fields to the "Fields To Display In Map" list box, and then click OK.</li>  Note that the Microsoft Map displays a dialog box as follows:

The following data from your worksheet is not recognized as geographic data:

<pre class="fixed_text">        USA Change to: </li></ol>

<div class="references_section">