"Stephen" <Stephefn@xjohnstontrading.com> wrote in message
news:OHOUTPzdEHA.1656@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:%23hHKz0zdEHA.236@tk2msftngp13.phx.gbl...
> sorry wrong group
> "Stephen" <Stephefn@xjohnstontrading.com> wrote in message
> news:OHOUTPzdEHA.1656@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
> >
> >
>
>