Results 1 to 2 of 2
  1. #1
    johny2011 is offline Member
    Join Date
    Apr 2011
    Rep Power

    Default Why I can not see number columns from my database ?

    I have an article database in excel. I import excel into an access table and use it in my java program.

    There are some string columns and 2 number columns in the excel file (issueNumber and year columns)

    After I import into access, I can see those numebr columns appear in the database.
    ->But I can not assign those number columns as integer during importing, if so does not import.

    When I made a query in java throught JDBC, the number columns (issueNumber and year) comes EMPTY, no records seen et al.Only column names seen.

    Anyone face to this problem before ? What can I do to see database in a proper way ?

  2. #2
    razmyasdfg is offline Member
    Join Date
    Jul 2008
    London (Kingsbury)
    Rep Power

Similar Threads

  1. How to write database queries in Jtable rows and columns?
    By Vignesh Karthick in forum AWT / Swing
    Replies: 1
    Last Post: 02-02-2011, 04:55 PM
  2. How to insert random number to database
    By waboke in forum New To Java
    Replies: 1
    Last Post: 09-24-2010, 04:45 PM
  3. Printing the Number of Times a Number in a Range Shows up
    By space4rent00 in forum New To Java
    Replies: 1
    Last Post: 02-05-2010, 11:42 PM
  4. Counting the number of columns in a 2D array,
    By KalEl in forum New To Java
    Replies: 9
    Last Post: 10-21-2008, 05:27 AM
  5. Displaying different columns with database query
    By jennybgh in forum JavaServer Pages (JSP) and JSTL
    Replies: 0
    Last Post: 08-02-2007, 05:04 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