I just downloaded the SQL add in for MS Mappoint, and I'm trying to create a view. I have a bunch of locations stored as LocID (Ident/Key), Name, Address, City, State, Zip, Zip3, Country, Longitude, Latitude.
How do I manually create a view so that I can use that view to create a layer? I tried selecting my locations table in the SQL add in, but it doesn't seem to recognize it as a valid view.