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

    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
    Location
    London (Kingsbury)
    Posts
    41
    Rep Power
    0

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, 05: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, 06: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, 06: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
  •