Results 1 to 2 of 2

Thread: Reading Xls file generate with SQLXLS

  1. #1
    Experienced Forum Member
    Join Date
    Mar 2009
    Location
    italy
    Posts
    166
    Rep Power
    579

    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. # 666
    Circuit advertisement
    Join Date
    Aug 1965
    Location
    Yakutsk, Russia
    Posts
    1,000,000
     

  3. #2
    Analyst DeadManWalks's Avatar
    Join Date
    Mar 2006
    Location
    Atlanta GA
    Posts
    1,586
    Rep Power
    3839

    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.
    Hiking the APT in 2015.

  4. # 666
    Circuit advertisement
    Join Date
    Aug 1965
    Location
    Yakutsk, Russia
    Posts
    1,000,000
     

Facebook Comments


Similar Threads

  1. How to generate the first line of my xml file?
    By Iaorana in forum RPG/RPGLE
    Replies: 6
    Last Post: March 7th, 2011, 01:29 PM
  2. Reading a file by %kds
    By jamief in forum /Free format
    Replies: 6
    Last Post: December 8th, 2006, 10:40 AM
  3. reading a file
    By casporov in forum RPG/RPGLE
    Replies: 1
    Last Post: November 6th, 2006, 06:48 AM
  4. Reading Flat file
    By nandas400 in forum RPG/RPGLE
    Replies: 0
    Last Post: May 25th, 2006, 12:44 PM
  5. Reading and XML file using RPG
    By Sheila Crawford in forum RPG/RPGLE
    Replies: 1
    Last Post: November 23rd, 2005, 11:59 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •