• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Importing and Linking Data > Importing Data and Databases

Importing Data and Databases

You can copy data from a number of different file formats to create a Microsoft Access table. In addition to copying data from a number of popular database file formats, Access 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, Paradox, and—using ODBC—any SQL database that supports the ODBC standard (including Microsoft Visual FoxPro).

Importing dBASE Files

To import a dBASE file, do the following:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint