I am trying to creat an application that takes an excel sheet, and imports it into a sql table. The hard part is, I needthe code to automatically generate the sql table based on the excel data. So if there is 3 columns of data, it will create a sql table with 3 columns. If there is 25 columns of data, it will create a sql table with 25 columns of data.
Any ideas? Can someone point me in the right direction?
It's not a easy task... but we can try it...:-) You can add a script component to your dataflow to generate and execute a CREATE Table statment in your database, based in the input columns of your excel file... Give me more details, like an exemple of excel files... Cheers!
The application I am trying to build needs to be able to upload any excel file, as long as the data starts in cell A1, and has column headers in each column. What other details can I give you?
