Author Login Chief Editor Login Reviewer Login Editor Login Remote Office

›› 2002, Vol. 28 ›› Issue (01): 281-283.

• Papers • Previous Articles     Next Articles

Implementation of Structured Query Outside Excel

WANG Mianyu, LIANG Jun   

  1. Institute of System EngineeringZhejiang Univ.Hangzhou 310027
  • Published:2002-01-25

对Excel实现外部结构化查询的方法

王勉宇,梁军   

  1. 浙江大学系统工程研究所,浙江大学系统工程研究所 杭州 310027

Abstract: This article describes how to use Visual Basic to query data in Excel with SQL through ISAM and ODBC drivers and illustrates the key points of creating tables and executing queries . ;;;;

摘要: 介绍在中如何通过和驱动程序对中的数据用进行查询,并通过实例说明了建表和执行查询时的注意点。VBISAMODBCExcelSQL

关键词: 结构化查询, Excel, VB, ISAM, ODBC

CLC Number: