Microsoft Access 2010 Bible

Part III: More-Advanced Access Techniques

632

FIGURE 17.26

Browsing to a dBase data file

Table 17.1 lists how the dBase data types are converted to Access equivalents.

TABLE 17.1

Conversion of Data Types from dBASE to Access

xBASE Data Type Access Data Type

Character Text

Numeric Number (property of Double)

Float Number (property of Double)

Logical Yes/No

Date Date/Time

Memo Memo

Note
When importing any dBASE database file in a multiuser environment, you must have exclusive use of the file. If
other people are using it, you won’t be able to import it.