 |
|
| 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.
| 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.
|
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.