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

Chapter 11. Importing and Exporting Info... > Getting Data from Other Programs

Getting Data from Other Programs

When you import data, you insert a copy of one file into another—in this case, Access. When you import data into Access, Access creates a new table to store the data, using labels from the first row of a worksheet or table for the new table. If you need to keep the data in a separate file for use in other programs, you can also link your data to a table in Access, which allows you to keep both updated. You can import or link data from a variety of sources, such as dBase, Microsoft Excel, Microsoft Exchange, Microsoft Outlook, HTML, Lotus 1-2-3, Paradox, SharePoint Team Services, and text files. You can use Access commands to edit the imported data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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