How to pass listbox values into an sql statement

[cpestrella]

Hello everyone!
I need some help. I'm trying to create an SQL Insert statement in VB and I need to pass the value of the listbox as fieldnames. It goes like this:

  sql = "Insert into TableName (List1.List(0), List1.List(1),.......) Values
           rs.Fields(0),rs.Fields(1),....)

Thanks.

[Killer42]

Hello everyone!
I need some help. I'm trying to create an SQL Insert statement in VB and I need to pass the value of the listbox as fieldnames. It goes like this:

  sql = "Insert into TableName (List1.List(0), List1.List(1),.......) Values
           rs.Fields(0),rs.Fields(1),....)

The SQL interpreter doesn't know anything about VB listboxes. What you need to do is get the values and concatenate them into the string. For example...

sql = "Insert into TableName  (" _
    & List1.List(0) _
    & "," _
    & List1.List(1) _
    ...
    & ") Values (" _
    & rs.Fields(0) _
    & "," _
    & rs.Fields(1) _
    & ","
    ...