Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 8 of 8

Thread: read excel sheet into database

  1. #1
    Junior Member
    Join Date
    Mar 2013
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default read excel sheet into database

    Hi

    I have write the java code with which I am able to read the excel file and display its contents on the console but I am unable to transfer the content to the database using mySQL.Could you please help me in doing what I need.Provide a code for doing that.


  2. #2
    Junior Member
    Join Date
    Mar 2013
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default How to import exelsheet into database

    Hi

    I have write the java code with which I am able to read the excel file and display its contents on the console but I am unable to transfer the content to the database using SQL.Could you please help me in doing what I need.Provide a code for doing that.

  3. #3
    Member Zyrion's Avatar
    Join Date
    Feb 2013
    Location
    Iowa
    Posts
    106
    My Mood
    Angelic
    Thanks
    2
    Thanked 8 Times in 8 Posts

    Default Re: How to import exelsheet into database

    What code have you accomplished so far? What have you tried?

    Read and write from Excel
    Java SQL Package

  4. #4
    Member Zyrion's Avatar
    Join Date
    Feb 2013
    Location
    Iowa
    Posts
    106
    My Mood
    Angelic
    Thanks
    2
    Thanked 8 Times in 8 Posts

    Default Re: read excel sheet into database

    What code have you accomplished so far? What have you tried?

    Read and write from Excel
    Java SQL Package

  5. #5
    Junior Member
    Join Date
    Mar 2013
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default how to transfer data on excelsheet into the database

    Hi

    i am shri i am started learning struts 2, please help me how to read excel data into database using struts2 with hibernate, please show me just sample application and some references and websites..

  6. #6
    Member Zyrion's Avatar
    Join Date
    Feb 2013
    Location
    Iowa
    Posts
    106
    My Mood
    Angelic
    Thanks
    2
    Thanked 8 Times in 8 Posts

    Default Re: how to transfer data on excelsheet into the database

    This is your third thread on the same topic:

    Thread 1
    Thread 2

    You should read about posting etiquette in this sticky thread: Read before posting

    Nobody is going to take you seriously if you keep posting threads with the same question. It shows us that you don't care about your previous threads; why should you be helped if you are probably going to ignore this one as well.

  7. #7
    Administrator copeg's Avatar
    Join Date
    Oct 2009
    Location
    US
    Posts
    5,264
    Thanks
    176
    Thanked 821 Times in 764 Posts
    Blog Entries
    5

    Default Re: read excel sheet into database

    The duplicate threads have been merged. Please do not start multiple threads with the same question, please only use the report button to report forum violations (not to draw attention to your posts), and please read the forum rules.

  8. #8
    Junior Member
    Join Date
    Feb 2013
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Re: How to import exelsheet into database

    hi

    Export your data from Microsoft SQL Server (and many other databases) to Microsoft Office Excel whit a few simply clicks. And importing your data back from Excel into your database is just as easy too.

Similar Threads

  1. Reading Excel sheet using apache poi 3.8
    By dnessapkota10 in forum What's Wrong With My Code?
    Replies: 0
    Last Post: December 11th, 2012, 04:42 AM
  2. How to create a password protected excel sheet....
    By ArunSRPM in forum Member Introductions
    Replies: 1
    Last Post: April 18th, 2012, 01:25 PM
  3. inserting problem in excel sheet for Java using Eclips
    By bdtuhin007 in forum JDBC & Databases
    Replies: 1
    Last Post: November 3rd, 2011, 08:44 PM
  4. appending from shell script to excel sheet
    By krishnamohan in forum Java Theory & Questions
    Replies: 1
    Last Post: August 16th, 2010, 10:01 AM
  5. how to copy cells to a new sheet of excel with JexcelAPI??
    By 19world in forum File I/O & Other I/O Streams
    Replies: 0
    Last Post: June 15th, 2010, 03:49 AM