I am using the Great Britain version of MappPoint2000. I have various datasets (as Acess Databases and comma separated text files) georeferenced to GB Ordnance Survey grid references. When I tried to create pushpin sets by importing the textfile data into MapPoint2000 I encountered some problems which I have not been able to overcome (the on-line help is very scant on detail on data importing):-
1. The import wizard only allows you to define one column as the location. The georeferencing of my datasets is stored as 6 figure national grid reference in 2 separate fields, one for the easting and one for the northing (ie. XXXXXX, YYYYYY) - this is normal practice with GIS data.
2. Undaunted I persevered and rejigged one of my datasets and combined the easting and northing into one field in the form of XXXXXX YYYYYY and re-imported it. It sort of of recognised it as OS data as it put it off the SW coast of Britain near the national grid origin (ie. 0,0) but obviosly did not gecognise it as 6 figure OS grid reference. It also only mapped 3 out of 106 records, but didn't tell me about the unmapped ones!
My question therefore is :-
1. What is the proper procedure for importing data that is georeferenced to GB Ordnance Survey grid references stored as separate 6 figure eastings and northings?
2. Is the procedure different (better?) for MapPoint2002?
PS I am an independant GIS consultant based in Edinburgh, Scotland and I am in the process of creating training courses in MapPoint (deatils from www.calmap.co.uk) - I noticed that one of the previous questions was from somebody looking for UK based MapPoint training.