I built a small program that reads in a text file and stores information from that text file in DIMed variables. I built an ODBC Command using the wizard (dragging the ODBC Command method onto the form). How do I pass the variables to the SQL string? I have INSERT INTO tblname (field1, field2) VALUES ( xx ) as the command named cmdInsertData. WHat do I put in the XX ? The VB variable name? Then do I just call the cmdInsertData.commandtext in the code? I can't find any examples like this.

Thanks

Access the Parameters collection of the Command object in order to add the necessary parameters. The exact syntax of the parameter names in the CommandTextmayn depend on the underlying datasource (or ODBC driver settings). Please see the MSDN documentation on the System.Data.Odbc.OdbcCommand object.

Access the Parameters collection of the Command object in order to add the necessary parameters. The exact syntax of the parameter names in the CommandTextmayn depend on the underlying datasource (or ODBC driver settings). Please see the MSDN documentation on the System.Data.Odbc.OdbcCommand object.