| Message |
One of my coworkers found a solution for me.
You need to install POIConverter (available at http://rjdavies.users.btopenworld.com/html/poiconverter.html).
In MS Streets file, zoom to the data and then "export map for pocket streets". This will create a .msp and a .psp file. The .psp file contains all the points data, but you'll need to convert it.
In POIConverter, open the .psp file and then choose save from the File menu. Save as a .csv file.
You can then import the .csv file into Access, making sure to choose deliminated, comma-separated file with " as the text qualifier and checking the "first row contains field names" box. This will import the data into 4 fields--lat, lon, name, and information. For particularly long records, you'll want to check for any information that may have been cut off at the end of the information field.
|