Excel2007中使用Microsoft Query处理外部数据的方法

Application of Microsoft Query Methods to Solve Outside Data in Excel 2007

Excel表格是一个简单的数据库,能够较好地处理简单而常用的数据。如果要处理大量的数据或处理来自其它数据源的数据,还需要借助其它数据库技术。将数据库技术和Excel结合起来,能够处理各种数据和开发大量的应用程序。本文通过使用Microsoft Office中的组件Microsoft query技术,描述了在Excel2007中动态导入外部数据的方法,从而实现EXCEL与其它数据库之间的数据共享,进而解决不同数据库之间数据的导入导出问题。

Excel is a simple Data Base,which can be solve simple and familiar data.It needs to ask for help from other Database technology,if solve large amount of Data or Data with source Data.Combine Database technology with Excel to solve support for various Data and development a great number of application program.The thesis describes methods that dynamic inputting outside Data in Excel 2007,throygh the use of Microsoft query technology of component with Microdoft office,thereby Data sharing between Excel and other Database,and that solve import and export problem between different Databases.