When accessing EXCEL, the DB query analyzer must add brackets or double quotation marks 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.
 

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

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.02 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.

 

 

 

2 5.02The 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.02 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.02.
 

Operating System: Windows 2000 Server Operating System

Foreground program: DB query analyzer 5.02

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 an error occurs when a single quotation mark or nothing is added before or after an Excel table name.

 

 

 

 

Figure 6 tables accessing the data source excel_odbc

 
 

Note that: For SQL access to an Excel data source, you must use double quotation marks (") or brackets (characters '[' and ']') to enclose the table name. Otherwise, the table name is enclosed in single quotes or nothing is added.An error is reported..

 

 

 

 

 

 

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