Follow the steps below to import data from a Microsoft Access database file:

 

Bring up the Data Source Creation Wizard, by navigating to Data->New Connection  Connect to an Access databases file by clicking on MS Access and selecting the desired file.   Access 2003 files usually have the extension MDB while Access 2007 files usually have the extension ACCDB.

 

Select the table or view you wish to import.   In this window you can also preview the data.

Before you click OK to complete the process, make sure field types are set correctly.  The type of a field directly affects the type of Dimensions created on it, and therefore affects the type of analyses it can be used with.  The type of field is indicated by an icon which is placed next to its name in the Preview box:

Icon	Meaning
	Text field
	Numeric field
	Date/Time field

In some scenarios, the automatically assigned type for a field may be incorrect.  If this happens, you can change the field’s type manually by right-clicking the field header and setting the correct field type.

See Also