my SQL statement works when I do a small part, but I have 83 fields I need to insert into a table in Access and Im try to remember how to do this. I know it is really easy.
strSQL = "INSERT INTO Table1 " _
& "(user_company, user_fname, user_lname) VALUES " _
& "('" & arrFill(1) & "', '" & arrFill(2) & "', '" & arrFill(3) & "');"
but how do I make it multiple lines? When my variables rap to the next line, Im not sure how to correctly code it.
strSQL = "INSERT INTO Table1 " _
& "(user_company, user_fname,
user_lname) VALUES " _
& "('" & arrFill(1) & "', '" & arrFill(2) & "', '" & arrFill(3) & "');"
Thank you