Previous Page | Next Page

File Format-Specific Reference for the IMPORT and EXPORT Procedures

Microsoft Access Database Files

Microsoft Access File Essentials

SAS/ACCESS Interface to PC Files works with Microsoft Access database 97, 2000, 2002, 2003, and 2007 files.

Microsoft Access is a desktop relational database system that uses the Microsoft Ace engine or the Microsoft Jet engine to store and retrieve data.

A database is a collection of information that is related to a particular subject or purpose, such as tracking customer orders or maintaining a music collection. If the size is greater than, or equal to MS Access database 2007, all objects in an MS Access database are stored in the Jet .mdb or Ace .accdb format.

The following table lists the maximum size limits for the methods of .mdb and .accdb files.

Microsoft Access Database (.mdb and .accdb) Maximum Size Limits Per Method
File size 2GB / 32,768 objects
Number of fields per table 255 units
Number of characters per text field 255 characters
Memo field size 65535 characters
Table name size 64 characters
Field name size 64 characters
Record size 2000 characters (excluding memo and OLE object fields) for .mdb

4000 characters (excluding memo and OLE object fields) for .accdb

While importing data from a table, SAS converts special characters in a table name to underscores ( _ ) in the corresponding data set name. If a field contains special characters, SAS converts special to underscores in the corresponding variable name.

Previous Page | Next Page | Top of Page