EXCEL table name will be enclosed in square bracket by DB Query ...
需积分: 9 120 浏览量
2013-08-21
12:44:57
上传
评论
收藏 310KB DOC 举报
DB Query Analyzer 5.03 is distributed, table name will be enclosed in
square bracket automatically while accessing MS EXCEL
1 Preface
DB Query Analyzer is presented by Master Gen feng, Ma from Chinese
Mainland. It has English version named ‘DB Query Analyzer’ and Simpli'ed
Chinese version named ‘万能数据库查询分析器（DB 查询分析器）’.
Out of question, DB Query Analyzer is one of the few excellent Client Tools
in the world for its’ powerful function, friendly interface, easy operation and
applicability to every production of RDBMS.
DB Query Analyzer lets you query ODBC data sources, author SQL scripts
and queries, return query results to a grid or free-form text or a 'le, retrieve
ODBC driver information, execute multiple SQL scripts or stored procedures
simultaneously, and more.
In the New products & Tools reviews of programmer second issue of 2007,
DB Query Analyzer had been strongly recommended.
Now DB Query Analyzer is the top 50 database application software in the
famous software website
http://xiazai.zol.com.cn/download_order/sub_550.html . In most case it lies
the top 20 and it has been download more than 92,000 times.
Master Gen feng Ma, the developer of DB Query Analyzer, hopes he can
cooperate with some software company such as Sybase, Embarcadero,
Microsoft and so on. He thinks it will be the better way that DB Query
Analyzer is assembled in the develop tools according to such software
company so that more and more database application software developer
will bene't from its powerful function, friendly interface, easy operation and
applicability to every production of RDBMS.
2 Access EXCEL by DB Query Analyzer
It‘s very powerful for DB Query Analyzer in EXCEL 'le process. I’ll give you
a sample to show its powerful function. Please make sure that column name
coinciding with the data should be included in the 'rst row in EXCEL 'le.
Also the table name must be enclosed in double quotation marks or square
bracket while accessing the ODBC Data source based on MS EXCEL.
1
资源评论
