Creating a database from a spreadsheet

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

The Geodatabase Builder tool allows you to create a personal or file 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 on the Defense Mapping toolbar.

   The Geodatabase Builder dialog box appears.

   

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

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

7. Click Add.
8. Click Select GDB.
9. Browse 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 review the log file or No to close the message.