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

Chapter 3. Getting Information Into and ... > Importing Information from Other Dat...

Importing Information from Other Databases

Importing information from databases other than Access is usually an all-or-nothing situation, and quite often, what you get isn’t in the exact format you need. You might find, for example, that transaction records include redundant information, such as the name of the product or purchaser, in every record. A database containing information about people might include the full name and address in one field, when you would like separate fields for the first name, last name, street address, and so on. You can choose to import information as it is and manipulate it in Access, or you can move it into some other program, such as Excel or Word, and manipulate it there before importing it into Access.


Access can import data from the following versions of dBASE, Lotus 1-2-3, and Paradox:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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