Linking an Excel Worksheet to Access

[ 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.


graphic/17fig21.gif



graphic/17fig22.gif



graphic/17fig23.gif


If your Excel worksheet has multiple worksheets, you can only link one sheet at a time.


graphic/17fig24.gif



graphic/17fig25.gif



graphic/17fig26.gif



graphic/17fig27.gif



graphic/17fig28.gif


[ LiB ]


Microsoft Office Excel 2003 Fast & Easy
Windows XP Registry: A Complete Guide to Customizing and Optimizing Windows XP (Information Technologies Master Series)
ISBN: N/A
EAN: 2147483647
Year: 2002
Pages: 157
Authors: Olga Kokoreva

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net