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!!!
Printable View
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!!!
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