sql problem

Results 1 to 2 of 2

Thread: sql problem

  1. #1
    Join Date
    Dec 1969

    Default sql problem

    &nbsp;<BR><BR>I am trying to insert data into access with a dsnless connection.<BR>can someone please help<BR>

  2. #2
    Mike Shaffer Guest

    Default RE: sql problem

    What is the problem you are having?<BR><BR>If you have opened the database connection, there are several ways you can go about inserting data. The simplest and most direct is something like this:<BR><BR> objDBConnection.Execute "insert into table1 (field1, field2, field3) values (&#039;value1&#039;, &#039;value2&#039;, &#039;value3&#039;)"<BR><BR>Does this help?<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts