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

Chapter 16. Sharing Data > Using Excel Data in Access

Using Excel Data in Access

Importing Excel data into Access can seem more complicated, but it really isn’t. You just have more options. You can import data directly into an Access table, or you can link to an Excel spreadsheet. What’s the difference? Imported data ends up in Access, whereas linked data stays in Excel—but you can still use it in Access. You’ll see how this works in the next two sections.

Importing Excel Data into an Access Table

Importing is usually a simple process of transferring (copying) data from one file to another. Access doesn’t change the data in any way. In this section, you’ll see how easily you can copy Excel data into an Access table. After the data is in an Access table, changes made to the original data in Excel don’t change the imported data in Access. Let’s import CatalogsInExcel.xls by doing the following:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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