Discover How To Link An Excel Spreadsheet To An Access Database

Have you ever wanted to use data from Excel in an Access database? Because Excel and Access both store data in tables in a similar way, each application can recognize data stored in the other application. As there are more Excel users than Access users there tends to be much more data stored in Excel compared to Access in some organisations, although much of this data could also be very useful in Access, with its more powerful capabilities to create queries, forms and reports. One way to use Excel data in Access is to link an Excel worksheet to an Access table. This article describes how to do this.

The full article appears here:
http://www.microsofttraining.net/article-1409-how-link-excel-spreadsheet-access-database.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com