Results 1 to 2 of 2

Thread: Importing an Excel xls into a DataSet in vb.net [RESOLVED]

  1. Nov 12th, 2003, 09:28 AM #1
    nokia8210
    nokia8210 is offline

    Thread Starter
    Lively Member nokia8210's Avatar
    Join Date
    Dec 2002
    Location
    Coventry
    Posts
    92

    Importing an Excel xls into a DataSet in vb.net [RESOLVED]

    Can Anyone help me? i have imported a txt file into excel and now i want the data in the xls spreadsheet to go into a dataet so i can manipulate it. Please help!!!
    Last edited by nokia8210; Nov 13th, 2003 at 05:51 AM.
    Reply With Quote Reply With Quote
  2. Nov 12th, 2003, 10:06 AM #2
    nemaroller
    nemaroller is offline
    I wonder how many charact
    Join Date
    Feb 2001
    Location
    Savage, MN, USA
    Posts
    3,704
    Well, if you have a recent version of Xcel, you could save the spreadsheet as an XML spreadsheet.
    Then use the Dataset.ReadXML.

    Now, you may or may not get great results, but it steps you in the right direction.

    http://msdn.microsoft.com/library/de...setfromxml.asp
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width