Excell sheet from second row second column to sql server 2000 table

Posted by Mahendrabasutkar under Sql Server on 6/8/2011 | Points: 10 | Views : 1386 | Status : [Member] | Replies : 9
How to place data from Excell sheet (from second row second column till end) to sql server 2000 table.

Thanks&Regards
mahendrabasutkar




Responses

Posted by: Nithadeepak on: 6/8/2011 [Member] Bronze | Points: 25

Up
0
Down
http://www.codeproject.com/KB/database/Excel2Sql.aspx

Nitha Deepak

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

Posted by: Vforvijay on: 6/8/2011 [Member] Starter | Points: 25

Up
0
Down
hi... Try this below link to get the data from excel file ...After get the data to datatable,you can select second row second column from the datatable and saved into Database...
http://vbdotnetaddict.blogspot.com/2011/01/import-excel-table-into-sql-table.html

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

Posted by: Mahendrabasutkar on: 6/8/2011 [Member] Starter | Points: 25

Up
0
Down
Thanks Nitha, but i want
How to place data from Excell sheet (from second row second column till end) to sql server 2000 table. using sql server 2000



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

Posted by: Mahendrabasutkar on: 6/8/2011 [Member] Starter | Points: 25

Up
0
Down
Thanks Vijay, but i want
How to place data from Excell sheet (from second row second column till end) to sql server 2000 table. using sql server 2000

Thanks&Regards
mahendrabasutkar

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

Posted by: Mahendrabasutkar on: 6/8/2011 [Member] Starter | Points: 25

Up
0
Down
Thanks Vijay, but i want
How to place data from Excell sheet (from second row second column till end) to sql server 2000 table. using sql server 2000

Thanks&Regards
mahendrabasutkar

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

Posted by: Vforvijay on: 6/8/2011 [Member] Starter | Points: 25

Up
0
Down
you are making confusing...you want import or export the data from excel.....

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

Posted by: Susanthampy on: 6/8/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
Hi

check this,

http://support.microsoft.com/kb/321686
http://support.microsoft.com/kb/306125

Regards,
Susan

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

Posted by: Susanthampy on: 6/8/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
Hi,

Try this also,

http://www.aspdotnet-suresh.com/2010/09/import-data-from-excel-to-sql-database.html

Regards,
Susan

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

Posted by: Mahendrabasutkar on: 6/8/2011 [Member] Starter | Points: 25

Up
0
Down
Hey dude,
I want to import data from Excell Sheet, from its second row second column, to sql table using sql server 2000

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

Login to post response