[AccessD] Re: still struggling with inserting to access table

Robert L. Stewart rl_stewart at highstream.net
Thu Oct 16 13:19:49 CDT 2003


Oleg,

You need to add a debug.print strsql and store your sql statement in that 
string.  i.e.

dim strSQL as string
dim i as integer
strsql = "INSERT into Table1Testing"
strsql = strsql & " (a, b) VALUES ("
for i = 0 to 8
      strsql = strsql & aRecord(i) & ", "
next i
debug.print strsql

This will allow you to build the string and look at it before you try 
executing it.  Once you can look at the SQL string, you will be able to 
trouble shoot it.

Robert

At 12:00 PM 10/16/2003 -0500, you wrote:
>Date: Thu, 16 Oct 2003 10:31:19 -0400 (EDT)
>From: <Oleg_123 at xuppa.com>
>Subject: Re: [AccessD] still struggling with inserting to access table
>To: <accessd at databaseadvisors.com>
>Message-ID: <57221.12.3.132.98.1066314679.squirrel at heck.bay9.com>
>Content-Type: text/plain; charset=iso-8859-1
>
>I thought I was using the default connection ?
>
>Also I tried it using this
>  DoCmd.RunSQL "INSERT into Table1Testing(a,b) Values(" & aRecord(0) & ", "
>& aRecord(8) & ")"
>
>but I get some pitiful results :(




More information about the AccessD mailing list