How can I insert all items in a multi column listbox on a excel Userform into a SQL Server DB table?
Each line of the listbox is 1 record for the table in sql server db. The listbox has 7 columns.
I am assuming that I need to loop through the listbox so that each row of the listbox is inserted as a record into the table in the DB
I have the connection to the DB sorted out and can insert to the DB from a textbox but not from a listbox.
Please help, I have been googling for 2 days and cannot find a solution.
Each line of the listbox is 1 record for the table in sql server db. The listbox has 7 columns.
I am assuming that I need to loop through the listbox so that each row of the listbox is inserted as a record into the table in the DB
I have the connection to the DB sorted out and can insert to the DB from a textbox but not from a listbox.
Please help, I have been googling for 2 days and cannot find a solution.