MicroStrategy ONE

Exporting a report to a Microsoft Access database

For a report exported to an Access database, you cannot change which report elements (such as title, details, data, headers, and SQL) are exported or whether the report formatting is exported (the options available on the Export Options: Appearance tab). To select which report elements to export, you can choose a different export format, update the export options, export the file, and then convert it to an Access database. For example, you can export the file to Excel and save it. In Access, import the Excel spreadsheet as external data.

To export a report to an Access database

  1. Run the report to export. (For steps to run a report, see Running a report.)

  2. If you want to configure export options, complete the following steps:

    1. From the Data menu, choose Export Options. The Export Options dialog box opens.

    2. Select MS Access Database from the Application drop-down menu. The options for exporting the report to Access are displayed.

    3. Click the General tab.

    4. To automatically open the report in Access after you export the report, select the Show application after exporting check box.

    5. If you send a report to your History List with the Export this report automatically check box selected, and then read the report from your History List, the report is automatically exported to Access.

    6. Type the File name to export the report to.

    7. Type the Table name to export the report to.

    8. To specify appending, overwrite, and error-handling conditions to the export request, click Advanced Options. For more information on these options, see Advanced Options for Exporting to Access.

      The Appearance tab is not used for exporting to Access.

    9. Click OK to return to the report.

  3. On the Data menu, point to Export To, then choose MS Access.

If you want the system to use the same file name and destination location or other export options each time you export a file, you can enter this information in the My Preferences area of MicroStrategy Developer. For details, see My Preferences dialog box: Reports tab, Export Options.