Problems with sql statement

hi to everyone…i have a problem… how can i execute and sql statement from visual basic ( trough out c/odbc) to get data from navision if the field of a certain table has a ‘.’ (point), example sql = “Select secciones.No from Secciones” rs.CursorLocation = adUseClient rs.CursorType = adOpenStatic rs.Open sql, conn MsgBox (rs.RecordCount)

Try using the “All except spaces” option for the Identifier in the C/ODBC Options, this should then work with “.” without any problems. Saludos Nils

thanks…gracias