ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Reading Xls file generate with SQLXLS

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Reading Xls file generate with SQLXLS

    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

  • #2
    Re: Reading Xls file generate with SQLXLS

    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

    Comment

    Working...
    X