[ LiB ] |
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.
If your Excel worksheet has multiple worksheets, you can only link one sheet at a time.
[ LiB ] |