problemas con el ( ' ) en una palabra

[sagma]

gracias por contestar freegirl.

Código:

Dim cmd As New OleDbCommand
cmd.CommandText = "SELECT acestnreg,clave,acestnomb,acperceid,'',acestplan,1,acestcarr,accardesc " & _
                           " FROM acest,acpin,accar,acper " & _
                          " WHERE accarccar = acestcarr " & _
                            " AND accarplan = acestplan " & _
                            " AND acestnreg = acpinnreg " & _
                            " AND acestnreg = acpernreg "
        cmd.CommandType = CommandType.Text
        cmd.Connection = conI

        Dim dr As OleDbDataReader

        dr = cmd.ExecuteReader

        'bucle para recorer del datareader
        While dr.Read
            ' en bucle registrar en access record a record
            'insert access

            sql = "INSERT INTO alumno VALUES ('" & dr(0) & "' , '" & Trim(dr(1)) & "' , '" & _
                                                   Trim(dr(2)) & "' , '" & Trim(dr(3)) & "' , '" & _
                                                   IIf(IsDBNull(dr(4)), "", dr(4)) & "' , '" & _
                                                   dr(5) & "' , '" & dr(6) & "' , '" & _
                                                   Trim(dr(7)) & "' , '" & Trim(dr(8)) & "')"

            cmd = New OleDbCommand
            cmd.CommandText = sql

este es parte de mi codigo, y me podria orientar como hacer para ponerlo como parametros??

gracias