I'm an Intern developing a tool to import data from excel with many sheets to sql server, i have been able to dynamically pass all the sheet names to combobox1 and sql server tables to combobox2. Further, combobox1.selecteditem(which is Excel Table) have passed all columns belonging to that selected table to Listview1 while combobox2.selecteditem have passed the sql table columns to listview4. How do i map the data of listview1.checkeditems(excel table columns) to the corresponding columns in listview4.checkeditems (sql table columns??=
And Option 2: I am also trying to import data directly from excel table (combobox1.selecteditem) to sql server table (combobox2.selecteditem)but it has foreign keys from many other tables. How to solve the foreign key constraint issue and what if some coulmn names are not the same from source to destination table???
Your kind and urgent response will serve my greatest interest.
I appreciates whatever effort put forth in helping me out.