Connect to Amazon DocumentDB from Microsoft Excel - Amazon DocumentDB

Connect to Amazon DocumentDB from Microsoft Excel

  1. Ensure that the Amazon DocumentDB driver has been correctly installed and configured. For additional information, refer to Setting up the ODBC driver in Windows.

  2. Launch Microsoft Excel.

  3. Navigate to Data > Get Data > From Other Sources.

  4. Choose From ODBC:

    The Get Data dropdown shows the From Other Sources submenu. The From ODBC option is selected.

  5. Select the data source from the Data source name (DSN) drop down menu that is associated with Amazon DocumentDB:

    The Data source name dropdown with the DocumentDB DSN option selected.

  6. Choose the collection from which you want to load data into Excel:

    The Navigator interface with the salaries table selected and a preview of its data.

  7. Load data into Excel:

    Excel spreadsheet showing five rows of data from the selected salaries table.