mixahlel
Last Activity: Apr 12 '13, 08:00 AM
Joined: Apr 9 '13
Location:
-
Could you provide me with code? -
concatenate a CREATE TABLE statement with my values from the first
i am trying to write a program in java where i would concatenate a CREATE TABLE statement with my values from the first row of excel file and hold the fields name to create the SQLStatement.
To be more specific i would like to create a table to store the data in a database where it will have as field the content of the first row of the excel file. I have a couple of excel files and for each of them i would like to create a table. Can... -
I have to do for a project in my school. That's why i am writing in here. But ok..thank you for your timeLeave a comment:
-
Could you provide me somewhere a link, an article to study?Leave a comment:
-
could you help me with the code?Leave a comment:
-
yes!next what i have to do?Leave a comment:
-
Yes, could you be more explanatory with code?Leave a comment:
-
No exactly! Let me be more specific! The excel files that i have contain the above:
ID NAME SALARY
232 SAM 4587
121 TIM 1254
542 PAUL 1247
12 JIM 4587
At the beginning i managed to read them with the code i send you before but i would like the result that shown in console to put them in a list!
How i will do this?Leave a comment:
-
store data from excel in list after reading with java
Hi,
i am using APACHE POI to read the data from excel files. I would like to store them in lists (like list in c) the result because afterwards I will try to store them in mysql database. What i will try to do is make this list and after i will use jdbc driver and giving this list to make the tables in mysql.
The code for reading excel file is the above:
...Code:import java.io.FileInputStream; import java.io.IOException;
No activity results to display
Leave a comment: