KB423169: How to define a Microsoft Excel 2007 file as a data source for MicroStrategy 9.3.1 projects?

Data saved in Microsoft Excel 2007 file as .xlsx format can be used as a data source for Strategy 9.3.1 projects. Strategy Tutorial project has a pre-defined database instance named "Excel Data Source" which can be used as reference.
 
Follow the steps below to define a Microsoft Excel 2007 file as a data source.
 
Prerequisites:
 
Microsoft Office 2007 32-bit version needs to be installed already.
 

1.  Open the Excel file, and then choose the data. Specify the table name in the name box.

• Open Strategy Connectivity Wizard, and choose "Other Relational Databases".

• Choose "Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)".

• Specify a name to DSN, and select the Excel file.

•  In Strategy Desktop 9.3.1, create a new database connection.

• Open the project which will use the excel file as a data source. And then open Warehouse Catalog to add the table in.

 
 
Third Party Software Installation WARNING
 
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability. 
KB423169