Creating a database from a spreadsheet

Data model information is provided as an Excel spreadsheet for most of the data models included with Defense Mapping. This is a format not usually accepted in ArcCatalog for data models; they are accepted as Access databases or XML files.

The Geodatabase Builder tool allows you to create a personal geodatabase from an Excel spreadsheet. The spreadsheet used with the tool should contain all the required information regarding feature classes, feature datasets, and domains.

Learn more about the Excel files used to create geodatabases

  1. Start ArcCatalog.
  2. On the main menu, click Customize > Toolbars > Defense Mapping.
  3. Click the Geodatabase Builder button Geodatabase Builder on the Defense Mapping toolbar.

    The Geodatabase Builder dialog box appears.

    Geodatabase Builder dialog box

  4. If necessary, click the Excel to GDB tab.
  5. Click Select XLS.
  6. Navigate to the Excel file to be used to build your geodatabase.

    The Excel files can be found in the <Defense Mapping installation location>\ESRIDefenseMapping\Desktop10\[ProductName]\Schema\XLS directory.

  7. Click Add.
  8. Click Select GDB.
  9. Navigate to the directory where you want to create the new geodatabase.
  10. Type a name for the geodatabase in the File name text box.
  11. Click Save.

    The Geodatabase Builder dialog box appears.

  12. Click Process.

    The geodatabase is created using the designated Excel file.

    When processing is complete, the Excel to Geodatabase message appears.

  13. Click Yes to view the log file or No to close the message.
  14. Click Cancel to close the Geodatabase Builder dialog box.