"Universal database query analyzer" 5.03 is released. Accessing EXCEL will automatically add brackets before and after the table name

"Universal database query analyzer" 5.03 is released. Accessing EXCEL will automatically add brackets before and after the table name

 
 

1 Introduction
 

The personal work released by Jack Ma, a local programmer in China, is the universal database Query Analyzer. The Chinese version is DB Query Analyzer and the English version is DB Query Analyzer. The latest version is 5.03. On the evening of June 14, the latest version has been updated on large software download websites in China, such as Zhongguancun online, huajun Software Park, Pacific computer, extraordinary software station, and Skynet.
 

Universal database query AnalyzerPowerful functions, friendly operation interface, good operability, spanning various database platforms, and evenEXCEL and text files.

 

You can use it to query data from ODBC data sources (including all databases on the world, TXT/CSV files, and EXCEL files. You can execute multiple DML statements and even the storage process at the same time, and the results will be returned in the table, text box, and file you set. When exporting tens of millions of data records from a database, the efficiency is no different from that of DBMS.
 

The Chinese version of "DB query analyzer" has been downloaded online for more than 90 thousand times in Zhongguancun, ranking first 20 in the database category list.
 

In the "New Product & tool comments" section of "programmer" 2007, "Special Recommendation" was edited and the "universal database query analyzer" was released.
 

This article will take version 5.03 as an example to describe in detail the Chinese version of "universal database query analyzer" "DB query analyzer" which is very powerful in EXCEL File Processing. Note that, the first line of an EXCEL file must contain a column name.

When DB query analyzer 5.03 accesses EXCEL, the system automatically generates three commonly used SQL statements that add a Forward Arc before and after the table name.

 

 

 

2 5.03The Chinese version of DB query analyzer is used as an example.
 

The following uses the Chinese version of the "universal database query analyzer" database query analyzer 5.03 as an example. On the Windows 2000 Server operating system as the platform, we first create a directory based on "D: \ the ODBC Data Source EXCEL_ODBC of an EXCEL file in the universal database query analyzer access the EXCEL data source, and then access the files in these directories through the DB query analyzer 5.03.
 

Operating System: Windows 2000 Server Operating System

Foreground program: DB query analyzer 5.03

Background File: EXCEL File
 

 

Figure 1 create an ODBC Data Source Based on an EXCEL file (1). Click "Tools"> "ODBC data source Manager" in the menu"

 

 

 

Figure 2 create an ODBC Data Source Based on an EXCEL file (2). Click "select Workbook" to select the EXCEL file to be accessed.

 

Figure 3 logon to EXCEL_ODBC

 

 

 

Figure 4 use an Object Browser to view the data source EXCEL_ODBC

 

 

Figure 5 accessing the data source EXCEL_ODBC table, DB query analyzer automatically generates one of the SQL scripts

 

 

Figure 6 accessing the data source EXCEL_ODBC table, DB query analyzer automatically generates SQL Script 2

 

 

Figure 7 accessing the data source excel_odbc table, database query analyzer automatically generates SQL script 3

 

 

 

 

Note:

If your computer is installed with a version earlier than "universal database query analyzer", uninstall the old version before installing the new version. Thank you!

 

 
 

 

Author profile:

Ma genfeng, Master, research direction: database application.

 

I have developed a universal database query analyzer. The Chinese version is dB query analyzer and the English version is dB query analyzer. It has powerful functions, friendly operation interface, good operability, spanning a variety of database platforms and even excel and text files.

 

I have also developed a file Delete absolutely to permanently delete files in windows without being recovered by other software.

 

These two software are free to use. They are downloaded from several major software download websites, such as Zhongguancun online, skysoftware station, huajun Software Park, Pacific computer, extraordinary software station, and green alliance.

 

 

 

DB query analyzer 5.03:
Http://xiazai.zol.com.cn/detail/27/264455.shtml

 

DB query analyzer 5.03:
Http://xiazai.zol.com.cn/detail/43/420901.shtml

 

 

Author's blog:

CSDN blog: http://blog.csdn.net/magenfeng

Sina Blog: http://blog.sina.com.cn/magenfeng

QQ space: http://user.qzone.qq.com/630414817