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 ?