How to create DB2 Table from XLS File

Question

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 · Answer

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.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded