I need to append to an existing table from a FoxPro DBF and I can't get
the syntax right.
I can open a recordset:

cnxn.Open "Driver={Microsoft Visual FoxPro
Driver};SourceType=DBF;SourceDB=h:\relayer\files;E xclusive=No"
rs.Open ("select cust.* from cust"), cnxn

I can work round my problem but would like to use INSERT INTO...
FROM... IN
Can anyone help with the syntax?

Thanks

You either need to walk through the recordset and add the records 1 by 1
(slower) or use something like:

INSERT INTO MyOtherTable
SELECT Cust.*
FROM Cust;
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"sam" <samdalal@spl.at> wrote in message
news:1140603345.317741.111420@o13g2000cwo.googlegr oups.com...[color=blue]
> I need to append to an existing table from a FoxPro DBF and I can't get
> the syntax right.
> I can open a recordset:
>
> cnxn.Open "Driver={Microsoft Visual FoxPro
> Driver};SourceType=DBF;SourceDB=h:\relayer\files;E xclusive=No"
> rs.Open ("select cust.* from cust"), cnxn
>
> I can work round my problem but would like to use INSERT INTO...
> FROM... IN
> Can anyone help with the syntax?
>
> Thanks
>[/color]

Doesn't work Arvin, I think I need an IN statement that identifies the
path and the database type similar to the connection string.

Arvin Meyer wrote:[color=blue]
> You either need to walk through the recordset and add the records 1 by 1
> (slower) or use something like:
>
> INSERT INTO MyOtherTable
> SELECT Cust.*
> FROM Cust;
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads
> http://www.datastrat.com
> http://www.mvps.org/access
>
> "sam" <samdalal@spl.at> wrote in message
> news:1140603345.317741.111420@o13g2000cwo.googlegr oups.com...[color=green]
> > I need to append to an existing table from a FoxPro DBF and I can't get
> > the syntax right.
> > I can open a recordset:
> >
> > cnxn.Open "Driver={Microsoft Visual FoxPro
> > Driver};SourceType=DBF;SourceDB=h:\relayer\files;E xclusive=No"
> > rs.Open ("select cust.* from cust"), cnxn
> >
> > I can work round my problem but would like to use INSERT INTO...
> > FROM... IN
> > Can anyone help with the syntax?
> >
> > Thanks
> >[/color][/color]

"sam" <samdalal@spl.at> wrote in
news:1140610702.608867.116790@g44g2000cwa.googlegr oups.com:
[color=blue]
> Doesn't work Arvin, I think I need an IN statement that identifies
> the path and the database type similar to the connection string.[/color]

Can't you just link to the DBF files directly?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Yes David, but this is not about resolving a problem but rather
learning something new.

David W. Fenton wrote:[color=blue]
> "sam" <samdalal@spl.at> wrote in
> news:1140610702.608867.116790@g44g2000cwa.googlegr oups.com:
>[color=green]
> > Doesn't work Arvin, I think I need an IN statement that identifies
> > the path and the database type similar to the connection string.[/color]
>
> Can't you just link to the DBF files directly?
>
> --
> David W. Fenton http://www.dfenton.com/
> usenet at dfenton dot com http://www.dfenton.com/DFA/[/color]

"sam" <samdalal@spl.at> wrote in
news:1140699327.401350.155770@z34g2000cwc.googlegr oups.com:
[color=blue]
> David W. Fenton wrote:[color=green]
>> "sam" <samdalal@spl.at> wrote in
>> news:1140610702.608867.116790@g44g2000cwa.googlegr oups.com:
>>[color=darkred]
>> > Doesn't work Arvin, I think I need an IN statement that
>> > identifies the path and the database type similar to the
>> > connection string.[/color]
>>
>> Can't you just link to the DBF files directly?[/color]
>
> Yes David, but this is not about resolving a problem but rather
> learning something new.[/color]

Well, then you should check the connect string on the linked DBF
file and model your IN statement in the SQL on that.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/