asp+excel book online retrieval system v3.8

asp+excel rural farmhouse book online retrieval system v3.8
Performance description: This is specially designed for online retrieval of books in rural bookstores. In the information age, simple retrieval functions can increase your work efficiency and get twice the result with half the effort.
1. The code is extremely simple. You can make slight improvements to use it in a fuzzy query system that suits you. It has a wide range of functions and is recommended for code learners to treasure.
2. The code is very versatile and can be applied to almost all three-choice fuzzy queries, such as product information query systems, without modifying the core code.
3. It is extremely easy to use. After modifying the five parameters, almost all other contents are controlled by the excel table, which directly supports all two-dimensional tables.

Operation steps
1. Open conn.asp in Notepad, modify the corresponding content in lines 2-6 of this page and save it. If you have any questions, please see the text explanation at the end.
2. Convert the excel data table provided by Nongjia Bookstore into a queryable two-dimensional excel table [refer to the demonstration data for table format].
3. Put the table together with the original data file. The file name can be arbitrary, the number of columns can be arbitrary, and multiple data files can be placed.
4. Upload the entire code directory to the space and access it through domain name + directory.

Troubleshooting
1. Check the excel sheet1 table! If not, just change it to sheet1.
2. Check whether the column headers of excel are consistent with the query conditions set in the conn.asp file.
3. Check whether it is a two-dimensional table. The first row is the column header, and the following rows are each piece of data. Please refer to the sample table for details.
4. For other errors, please carefully follow the #DataConversion# below to convert the Excel table.

Data transformation
1. Create a new excel file: Create a new book1.xls file--->Select all tables--->Format--->Cells--->Number--->Select text--->OK
2. Remove the original format: Open the original .xls database--->Copy all contents of the table--->New Notepad file--->Paste--->Select all--->Copy
3. Paste the de-formatted data into a new file: Paste the copied results into book1.xls--->Save--->Rename to your database--->Overwrite the original database