"William Gower" <w_gower@hotmail.com> wrote in message
news:%23PiM1U2dEHA.592@TK2MSFTNGP11.phx.gbl...
> Is that just a typo where you don't have a space between master and where?
>
> "Stephen" <Stephefn@xjohnstontrading.com> wrote in message
> news:%23pzOo$zdEHA.3612@TK2MSFTNGP09.phx.gbl...
> > Hello
> > I want to insert data from TABLE Master into TABLE tempAr. I have the
> > following so far. Both tables are in a Access Database
> > What am i doing wrong?
> >
> > steve
> > SQLStatement = "Insert into tempAr(MasterId,Payment)(Select
> > MasterId,Cust_leasePmt from masterwhere cust_methodofPayment=2)"
> >
> > SetUpDataBase()
> >
> > reader = cmd.ExecuteReader()
> >
> >
> > conn.Close()
> >
> >
> >
> > Private Sub SetUpDataBase()
> >
> > On Error Resume Next
> >
> > conn.Close()
> >
> > conn.ConnectionString = cs
> >
> > conn.Open()
> >
> > cmd.CommandType = CommandType.Text
> >
> > cmd.Connection = conn
> >
> > cmd.CommandText = SQLStatement
> >
> > End Sub
> >
> >
>
>

"Stephen" <Stephefn@xjohnstontrading.com> wrote in message
news:%23pzOo$zdEHA.3612@TK2MSFTNGP09.phx.gbl...
> Hello
> I want to insert data from TABLE Master into TABLE tempAr. I have the
> following so far. Both tables are in a Access Database
> What am i doing wrong?
>
> steve
> SQLStatement = "Insert into tempAr(MasterId,Payment)(Select
> MasterId,Cust_leasePmt from masterwhere cust_methodofPayment=2)"
>
> SetUpDataBase()
>
> reader = cmd.ExecuteReader()
>
>
> conn.Close()
>
>
>
> Private Sub SetUpDataBase()
>
> On Error Resume Next
>
> conn.Close()
>
> conn.ConnectionString = cs
>
> conn.Open()
>
> cmd.CommandType = CommandType.Text
>
> cmd.Connection = conn
>
> cmd.CommandText = SQLStatement
>
> End Sub
>
>

"Stephen Martinelli" <stephenx@johnstontrading.com> wrote in message
news:%23qK$Xh2dEHA.2520@TK2MSFTNGP12.phx.gbl...
> just a type
>
> "William Gower" <w_gower@hotmail.com> wrote in message
> news:%23PiM1U2dEHA.592@TK2MSFTNGP11.phx.gbl...
> > Is that just a typo where you don't have a space between master and
where?
> >
> > "Stephen" <Stephefn@xjohnstontrading.com> wrote in message
> > news:%23pzOo$zdEHA.3612@TK2MSFTNGP09.phx.gbl...
> > > Hello
> > > I want to insert data from TABLE Master into TABLE tempAr. I have the
> > > following so far. Both tables are in a Access Database
> > > What am i doing wrong?
> > >
> > > steve
> > > SQLStatement = "Insert into tempAr(MasterId,Payment)(Select
> > > MasterId,Cust_leasePmt from masterwhere cust_methodofPayment=2)"
> > >
> > > SetUpDataBase()
> > >
> > > reader = cmd.ExecuteReader()
> > >
> > >
> > > conn.Close()
> > >
> > >
> > >
> > > Private Sub SetUpDataBase()
> > >
> > > On Error Resume Next
> > >
> > > conn.Close()
> > >
> > > conn.ConnectionString = cs
> > >
> > > conn.Open()
> > >
> > > cmd.CommandType = CommandType.Text
> > >
> > > cmd.Connection = conn
> > >
> > > cmd.CommandText = SQLStatement
> > >
> > > End Sub
> > >
> > >
> >
> >
>
>

On Sat, 31 Jul 2004 13:49:35 -0700, "Stephen" <Stephefn@xjohnstontrading.com> wrote: