Hi everyone
how do i create a table based on the name(s) of excel(or Sheets) file that you are importing(or looping through), and at the same time import the data from that excel(Sheets) file into the created table in the database
all i have done is, i can loop through the excel file, and create the table into the database based on the name of the iterated excel file, but i dont know how to import the data from that excel file. i will be really happy if you can provide this as a solution that uses excel sheets
Thanks
Cecil
Hi Cecil,
Welcome to the community.
Take a look at the answer I gave in this following post:
http://biresort.net/forums/t/30.aspx
Helped?
regards,
Pedro
Hi Pedro
I have already saw the information from that link, but now my problem is i couldnt get hold of the solution that you said you will publish, if i can at least get my hands on the solution so that i should know how you created the tables and importing their according to the iterated spreadsheet,
all i have done is i can iterate through all excel files, and create the table per each iterated excel file , but the problem is i am getting an error when i try to import dat on the data flow side... please help please
Could you attach here the package or send to my email?
Regards,
h Pedro
i was just letting you know that i manage to fix the problem i had last time, so no need to worry about it
Very good!!