how to export data from spreadsheet to datatable?

Posted by Cc9530 under C# on 12/12/2010 | Points: 10 | Views : 1389 | Status : [Member] | Replies : 3
Hi experts,

i want to know what's the best way to export data from spreadsheet to datatable? maybe, any way that can export data from spreadsheet to datatable.
my way:http://www.e-iceblue.com/Knowledgebase/Spire.XLS/Demos/DataTable.html

Thanks for any answers.

i could be the one


Responses

Posted by: Ankitwww on: 12/13/2010 [Member] Starter | Points: 25

Up
0
Down
Can't say that its best way, but I found SSIS package creation is a simple way for it. you can find many demos online for it.

PS: QuestPond (www.questpond.com) have a nice demo on SSIS.

Cc9530, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 12/13/2010 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
i think i have given the example answer to this , but i think it was a long time ago, or years ago

http://www.dotnetfunda.com/forums/thread879-need-to-save-the-data-in-excel-which-is-exported-from-a-datacontrol-in.aspx

Thank you for posting at Dotnetfunda
[Administrator]

Cc9530, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response