Results 1 to 2 of 2
  1. #1
    saran123 is offline Member
    Join Date
    Oct 2008
    Posts
    5
    Rep Power
    0

    Default how to insert date field read from Excel using JExcel to database

    hI,
    i am reading data from Excel usign JExcel api and storing it in Ms access database. Now its showing "Data Type mismatch" error while trying to insert the values into database .Because two fields ar ein date format.I dont know how to take that date field and store it in dateFormat. Please provide me some solution.Thanks.

    Cell cell = sheet.getCell(j,i);
    cell.getContents();

  2. #2
    DevzAbhi's Avatar
    DevzAbhi is offline Member
    Join Date
    Jul 2008
    Posts
    67
    Rep Power
    0

    Default

    preparedStatement.setDate(int parameterIndex, Date cell)


    i hope this helps ..

Similar Threads

  1. Replies: 0
    Last Post: 06-21-2008, 11:53 AM
  2. Probeleme with insert into database oracle
    By bachtoutou in forum New To Java
    Replies: 0
    Last Post: 05-24-2008, 12:56 PM
  3. Replies: 0
    Last Post: 02-10-2008, 12:25 PM
  4. Replies: 2
    Last Post: 07-02-2007, 05:25 PM
  5. problem with date field
    By Ed in forum JDBC
    Replies: 2
    Last Post: 06-12-2007, 05:27 PM

Posting Permissions

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