importing Excel data into Access seldom produces the exact table structure you ultimately need. Still, it’s a good idea to let the import process properly arrange as much of the data as possible.

ArcMap, a part of the ArcGIS geographic-information system software from the Environmental Systems Research Institute, can be used in conjunction with Microsoft Excel. If you want to use some or all ...