Microsoft Access is a well-known database management system. The data is stored using tables. Upon creating tables, you can add many different data field types to them, such as currency, hyperlink, ...

In the Fields section, create the fields you need for your table. For example, if you have a table for customers, you might add fields for first name, last name, address, city, state, zip code, email, ...

In Microsoft Access, a Relationship helps you to merge or link data from one table to another. Relationships allow the user to create Queries, Forms, and Reports.

How to: MS SQL to MS Access. Microsoft Access provides tools that make it relatively easy to load data from a variety of external data sources and in many different formats.

Unfortunately, no. In Access 2003, FoxPro is not a listed File Type when using Get External Data, Link. The only references to .dbf ar ethe DBase III, IV and V types.