Wednesday, July 09, 2008

Using Access and Excel Together

The MS portal, Office Online, has posted a substantial article on using Access and Excel together to manage data solutions: Top 10 reasons to use Access with Excel. This is the introduction to the article:
When using the Office family of products, should you use Excel or should you use Access to manage your tabular data? A companion article, Using Access or Excel to manage your data, recently discussed the benefits of each product and what they "bring to the table". But why choose between one or another? If you store your data in Access and connect to it from Excel, you gain the benefits of both. Here are ten reasons why a marriage between Excel and Access makes lots of sense. Excel users, don't be afraid to let go of your data. Think of it this way. You're not losing an Excel daughter; you're gaining an Access son-in-law.