Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008
    Posts
    4
    Rep Power
    0

    Smile Excel to database using java

    Hi there,

    I have received the requirement for reading excel spreadsheet and export its data into our SQL Server database. The spreadsheet contains 3 workbooks, each one has huge rows with around 20 to 30 columns. I would like to determine how to read excel data to database and what could be the best approach to implement the functionality. The thing is that in each row some columns has to go different table and some columns to its associated tables. If data is not found in excel for particular record, then we make sure not null constraints table are also ensured.

    Do reply the best solution for this approach.

    Thanks,
    Priyadharshini.S.

  2. #2
    CaptainMorgan's Avatar
    CaptainMorgan is offline Moderator
    Join Date
    Dec 2007
    Location
    NewEngland, US
    Posts
    835
    Rep Power
    9

    Default

    Amazing what google can provide to you. A similar question was asked offsite, and a possible solution suggested. What are the search words I used you ask? "java read excel page"

    Best of luck with your requirement. :)
    Vote for the new slogan to our beloved Java Forums! (closes on September 4, 2008)
    Want to voice your opinion on your IDE/Editor of choice? Vote now!
    Got a little Capt'n in you? (drink responsibly)

Similar Threads

  1. writing to a excel file from java program
    By priyankabhar in forum New To Java
    Replies: 15
    Last Post: 01-17-2014, 01:39 PM
  2. Upload excel data to access database
    By ravikumar.achi in forum New To Java
    Replies: 20
    Last Post: 01-19-2012, 12:30 PM
  3. Java Database Connectivity
    By Java Tutorial in forum Java Tutorial
    Replies: 0
    Last Post: 01-14-2008, 02:11 PM
  4. Problem connecting to my Database using Java
    By javaneed in forum New To Java
    Replies: 3
    Last Post: 08-13-2007, 10:35 AM
  5. PDA, Database, and Java
    By percivalwcy in forum CLDC and MIDP
    Replies: 0
    Last Post: 08-08-2007, 04:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •