Export / import data from Excel to SQL database

Tags:
Microsoft Excel
SQL Database
VB.NET
Hi, I want to do one program in which I have one Excel sheet that some data can be stored. I want to import that data in VB.NET application and store it in a SQL database and do same thing vice versa. Which means I can fetch data from SQL database through VB.NET and store that data in Excel. Please help me in this.
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    And what problem are you running into when you try? There are numerous tutorials about VB.NET interacting with Excel, and accessing a SQL database with VB.NET is also covered in many places. A couple Google searches brings many results.

    We can't simply copy stuff from tutorials and put it into an answer. If you're having trouble with info that's already on the internet, we'd just be duplicating the same problem for you. We need to know what the actual problem is in order to help solve it.

    What does your VB.NET code look like? What problem happens when you run it?
    35,650 pointsBadges:
    report
  • ToddN2000
    Post the scripts you have tried and any error messages. We can help you clear them up.
    133,740 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: