Special Edition Using Microsoft® Office XP

Exporting and Importing Data

Sooner or later—probably sooner—you'll want to transfer information stored in an Access database to some other software environment, or move data originally created in another program into Access. In some cases, you'll want to move entire tables between database programs for use in different applications. For example, you might want to copy a table of supplier names and addresses from Access so that another database developer can incorporate that data into an application created with SQL Server or Oracle. Or, if you're building an Access database to replace an application created in an older program, such as dBASE, FoxPro, or Paradox, you might need to import data twice—once when you begin designing the database, ...