O'Reilly logo

Microsoft® Access® 2010 Inside Out by Jeff Conrad and John Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Importing Data and Databases

You can copy data from a number of different file formats to create an Access table. In addition to copying data from a number of popular database file formats, Access 2010 can also create a table from data in a spreadsheet or a text file. When you copy data from another database, Access uses information stored by the source database system to convert or name objects in the target Access table. You can import data not only from other Access databases but also from dBASE and—using ODBC—any SQL database that supports the ODBC standard.

Inside Out: What Happened to Paradox and Lotus File Support?

In Access 2010, Microsoft has deprecated support for importing or linking to Paradox and Lotus files.

Importing dBASE Files

On ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required