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

Chapter 17. Using Excel with Access > Linking an Excel Worksheet to Access

Linking an Excel Worksheet to Access

Another way to connect an Excel worksheet to an Access database is by creating a link. When you create a link, you can update the data in Excel as needed, and the changes will be reflected in the Access database as well. There is no need to reimport the data each time you change it in Excel.




PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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