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
Try another db to xl product and see if you can then read that. If so then that sql2xls blows, if not and both can open in excel, then the .net is wrong.
Hunting down the future ms. Ex DeadManWalks. *certain restrictions apply