问题描述
我是一名实习生，正在开发一种工具，可以将具有多个工作表的excel数据导入sql服务器，我已经能够将所有工作表名称动态传递给combobox1，并将sql server表传递给combobox2.此外，combobox1.selecteditem(Excel表)已将属于该选定表的所有列传递给Listview1，而combobox2.selecteditem已将sql表列传递给listview4.如何将listview1.checkeditems(excel表列)的数据映射到listview4.checkeditems中的相应列(sql表列?? =
选项2:我也试图将数据直接从excel表(combobox1.selecteditem)导入到sql服务器表(combobox2.selecteditem)，但是它具有来自许多其他表的外键.如何解决外键约束问题，以及从源表到目标表的某些库伦名称不相同怎么办?
您的亲切和紧急的回应将使我最大的兴趣.
我感谢为帮助我所做的一切努力.
谢谢
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.
Thanks
推荐答案
这篇关于将数据从Excel导入Sql Server的工具的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！