Import a Microsoft Access database file

You can create an Analytics table by defining and importing a Microsoft Access database file.

The Access file can be any version from Access 2000 to Access 2010. To import a file from an earlier version of Access you can save the file in another file format that Analytics can define and import.

You can import an Access file even if you do not have Microsoft Access installed on your computer.

1. Select File > New > Table.
2. If the Select Platform for Data Source page is displayed, select Local and click Next.
3. Select File and click Next.
4. In Select File to Define, locate and select the file you want to create the Analytics table from and click Open. Microsoft Access database files have a .mdb or .accdb file extension.
5. In the File Format page, verify that the Access database option has been selected and click Next.
6. Complete the following steps in the Data Source page:
   1. Select the table or view to import. The available options are listed in the Select the Access Table/View list.
   2. If you want to increase or decrease the maximum number of characters imported from text fields, enter a new value in the Maximum Character Field Length text box.

      You can enter from 1 to 255 characters.

   3. If you want to increase or decrease the maximum number of characters imported from memo or long text fields, enter a new value in the Maximum Memo Field Length text box.

      You can enter from 1 to 32767 characters (non-Unicode Analytics), or 16383 characters (Unicode Analytics).

   4. Click Next.
7. In the Save Data File As dialog box, modify the filename and location for the Analytics data file, as necessary, and click Save.
8. In the Final page, verify the settings for the new Analytics table and click Finish.
9. Enter a name for the Analytics table you are adding to your project and click OK.