How to create DB2 Table from XLS File

[dustin_davidson1]

I am trying to create a new table in DB2 from an existing excel file.  I used the <cfspreadsheet> to organize the data into a query object(should I use the query object or just a spreadsheet object).  I am not sure how to load the data.  Should I use <cfquery> to create a new table and then <cfloop> the query object(from the spreadsheet) to insert(sql statement) the data into the table.  I am two weeks into learning CF so explain things to me like I am a 2yr old.  Here is what I have coded so far.

[Dan_Bracuk]

My suggestion is to back away from your code and think about what you are doing.  Creating a new table everytime someone uploads a file isn't likely to result in useable data.

[dustin_davidson1]

This is just a project.  It is not going to be used in a real setting.