Originally Posted by MythicZombie
I already know how to get data from excel and then inserting it into the access file table. However the problem is that I want to display it in the browser as a table and have the same arrangements it has in the excel file, meaning if there are 3 columns, display 3 columns, if there are 5, display 5.
I do not know how to construct the sql statement which will add the same number of columns the excel file has into access. But if there is a better way of doing it, please tell me.
This is all unecesary , that is converting to access, if you are just displaying exactly what it is in excel file. Read from excel and display as html table.
I see it is a big hole i your knowledge, will give you a peace of code , doh doubt it will help, mybe will give you some ideas:
This is connected to mysql, in your case it should be to msaccess
mc.mysql.mysqlconnection con = new mc.mysql.mysqlconnection(this.getClass().getName());
con.setDataSet("the SQL statement that you have no idea how to write it, nither do I as I know 0 about your table");