JDBC connection to excel strings

You can use the select * From sheet1 $ method to read data, which is as convenient as normal select statements. However, two problems were encountered in the middle: 1. when you use the default method to read data, the first row in Excel will become the column title, rather than the Data Reading; 2. the merged cell data and text information in some numeric columns are lost. After checking N records for a long time, we found that the above two problems can be solved by adding additional parameters in the connection string of the ADO control. Driver ProgramUse: provider = Microsoft. jet. oledb.4.0; data source, pointing to the Excel file data source=abc.xls you need to read; you need to specify the following additional parameters to read the Excel file; and the next two parameters, extended properties = Excel 8.0; HDR = no; IMEX = 1; the parameters HDR and IMEX mean HDR = yes; "indicates that the first row contains columnnames, not data" IMEX = 1; "tells the driver to always read" intermixed "Data columns as text HDR = No, the first line is data, not the title! If the above connection string parameter is not set correctly, the system will throw Unable to find the installable isamError!