Hi everyone, would like to import data from an excel table into a SQL table. The problem is that the data from only one Excel table has to be imported into 3 different tables of the same sql-database. So the main problem in my eyes is to associate every excelcolumn to the matching column of one of the trhee diffferent sql-tables. Of course this has to be done manually by the user. I could immagine two listboxes on a form. First-one for the excelcolumns (source) and anotherone for the sqlcolumns(destination) A third listbox could display the columns the user put together. I have already managed to get the excel-data displayed in a datagridview without opening the excelfile with this code.

oAdapter = New System.Data.OleDb.OleDbDataAdapter( _
"SELECT * FROM [" & strSheetName & "]", OleDbExcelConn)

thanks in advance, Jeiss