how to read excel and store the data in database

Question

0.00/5 (No votes)

See more:

Dear all,

I want to save the data from excel to the database and export data from datagrid to excel. Please help me out

Thanks and regards,
mvengaqu

Posted 18-Dec-11 5:52am

mvengaqua

Add a Solution

Comments

mvengaqua 18-Dec-11 11:54am

IN VB.NET

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Accepted Answer · 2011-12-18T06:02:00

Solution 1

To read data from excel, this[^] article could be useful to you.

To export data, you can go through Export to Excel using VB.Net[^].

Posted 18-Dec-11 6:02am

Abhinav S

Comments

mvengaqua 18-Dec-11 12:03pm

thanks abhinav

Abhinav S 18-Dec-11 12:06pm

You are welcome.

Sergey Alexandrovich Kryukov 18-Dec-11 12:40pm

My 5.
--SA

Abhinav S 18-Dec-11 12:42pm

Thank you SA.

mvengaqua 19-Dec-11 3:20am

i want to do this in vb.net and not in asp.net. Please tell me for vb.net

Amir Mahfoozi · Accepted Answer · 2011-12-18T06:15:00

Solution 2

For importing data from an excel fine the OPENROWSET command will help you :
http://support.microsoft.com/kb/321686[^]

http://jasonhaley.com/blog/post/2004/03/06/OPENROWSET-T-SQL-function.aspx[^]

www.sqlservercentral.com/Forums/Topic496226-148-1.aspx[^]

Of course datagrids don't have data by their own and they are linked to a datasource that you should work with them. so to dump data in a datasource into an excel spreadsheet read these pages :
http://www.dotnetperls.com/excel-vbnet[^]

http://stackoverflow.com/questions/3096090/fastest-way-to-write-cells-to-excel-with-office-interop[^]

Hope it helps.

Posted 18-Dec-11 6:15am

Amir Mahfoozi

Comments

Sergey Alexandrovich Kryukov 18-Dec-11 12:41pm

Should be useful, my 5.
--SA

Amir Mahfoozi 18-Dec-11 23:57pm

Thank you :)

Abhinav S 18-Dec-11 12:42pm

Good links.5.

Amir Mahfoozi 18-Dec-11 23:58pm

Thank you :)

Wendelius 18-Dec-11 13:26pm

Good answer, 5'd

Amir Mahfoozi 18-Dec-11 23:58pm

Thank you :)