本文主要是介绍Microsoft Excel and Access Integration: With Microsoft Office 2007,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
版权声明:原创作品,允许转载,转载时请务必以超链接形式标明文章原始出版、作者信息和本声明。否则将追究法律责任。 http://blog.csdn.net/topmvp - topmvpExcel users. Access users. You're probably among the majority, living in one camp or the other but rarely crossing between the two. Yet Microsoft designed these applications to work together. In this book, you'll discover how Access benefits from Excel's flexible presentation layer and versatile analysis capabilities, while Access's relational database structure and robust querying tools enhance Excel. Once you learn to make the team work, you'll find that your team's productivity is the real winner.
*Move data easily between Excel and Access*Store Excel data in a structured relational database
*Create Excel PivotTables with Access data
*Report Access data using Excel's presentation layer
*Use VBA, ADO, and SQL to move data from one application to the other
*Save time and increase productivity by automating redundant processes with VBA
*Simplify integration tasks using XML
*Integrate Excel data into other Office applications
http://rapidshare.com/files/47852021/0470104880.zip
http://depositfiles.com/files/1437888
这篇关于Microsoft Excel and Access Integration: With Microsoft Office 2007的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!