Hi All
in As400 i run the command SQL2XLS/SQL2JXL (http://www.mcpressonline.com/tips-t...e-fly.html -http://www.mcpressonline.com/tips-t...lapi.html) to generate Xls file; but when we try to read this Xls with a VB net program (connection OleDbConnection "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & sorgente & "; Extended Properties=""Excel 8.0;HDR=No;". ) the last row is lost. If we open this Xls file with excel and then save it and we read again with the VB net program, all the rows are processed . Any idea how solve the problem ?
Thanks in advance
in As400 i run the command SQL2XLS/SQL2JXL (http://www.mcpressonline.com/tips-t...e-fly.html -http://www.mcpressonline.com/tips-t...lapi.html) to generate Xls file; but when we try to read this Xls with a VB net program (connection OleDbConnection "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & sorgente & "; Extended Properties=""Excel 8.0;HDR=No;". ) the last row is lost. If we open this Xls file with excel and then save it and we read again with the VB net program, all the rows are processed . Any idea how solve the problem ?
Thanks in advance
Comment