Using the Pd Data Extractor.

Solution

The custom data prep program extracts data from a database into a text file that Intersection Magic can import. You must have a supporting configuration and version 6.685 or higher.

1. Open Intersection Magic.
2. Select Utilities/Database/Import.
3. Click the button ÒClick here to execute your custom data prep programÓ.
4. Click the button ÒClick here to select the input database file nameÓ.
5. Browse to the MS Access data file from that you would like to import. It should have a *.mdb extension. (The default database is Access, but others can be selected in the advanced tab).
6. Click the button ÒClick here to begin extractionÓ, and accept the default location for the temporary text file.( If you need to change the file location and/or name click on the ÒClick here to select the output file nameÓ)
7. Click the Ok button when the extraction has finished.
8. Click the Exit button to close the Pd Extractor window.
9. Click the Ok button in the Import window to begin the import process.
10. Click the Yes button to confirm the Import.
11. Review the logs when finished.
12. If everything was done correctly it should only contain one error ÒImport errors   (critical errors. record not imported): 1Ó Line one will not be imported. Line one contains the field definitions for the import file, and is not imported.