Using pb saveas export excel dw_1. Saveas (' ct. XLS, Excel5! , true)
And then through the following link
The db="ct. XLS"
ExcelConn. Open="provider=Microsoft. Jet. The OLEDB. 4.0; Data source="& amp; Server. The MapPath (db) & amp;" ; Extended Properties=5.0 Excel;"
The set rsexcel=excelconn. Execute (" SELECT * FROM [ct $] ")
Unable to open the

But if I open the excel file in excel program, then save up, choose to keep the format, can be opened, could you tell me why????????

CodePudding user response:

Original concept enumerated value Web DataWindow or Java field Numeric value a fancy
Excel! DW only Excel (Web) 0 Microsoft Excel format
The Text! The Text (Web DW only) 1 (the Default) Tab - separated columns with a return at the end of each row
CSV! DW only CSV (Web) 2 - separated values
SYLK! SYLK DW only (Web) 3 Microsoft Multiplan format
WKS! DW only WKS (Web) 4 Lotus 1-2-3 format
WK1! DW only WK1 (Web) five Lotus 1-2-3 format
DIF! DW only DIF (Web) 6 Data Interchange Format
DBASE2! DW only dBASE2 (Web) 7 dBASE - II format
DBASE3! DW only dBASE3 (Web) 8 dBASE III - the format
SQLInsert! SQLInsert DW only (Web) 9 SQL syntax
The Clipboard! The Clipboard (Web DW only) 10 Save an image of the graph to the Clipboard
PSReport! PSReport 11) Report format (PSR)
WMF! WMF DW only (Web) 12 Windows Metafile format
HTMLTable! HTMLTable 13 HTML TABLE, TR, and TD elements
Excel5! Excel5 DW only (Web) and Microsoft Excel Version 5 format

CodePudding user response:

Dw_1. Saveas (' ct. XLS, Excel! , true)
Try.

CodePudding user response:

Attention!

CodePudding user response:

The original poster at the statement to try to join the following statement

Int result
Ole_object=CREATE OLEObject
Any nr
String f_name//excel file name
IF ole_object. ConnectToNewObject (" Excel. Application ") & lt;> 0 THEN
MessageBox (' OLE errors', 'Excel has not been installed! ')
RETURN
END the IF
Ole_object. Workbooks. Open (f_name)
Ole_object. Application. The visible=true

CodePudding user response:

With low version format, with high version drive open it,,,

With your eyes closed to answer your question, because it is very tired,,