INSERT INTO Acess 2K table from Visual FoxPro DBF

[sam]

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

[Arvin Meyer]

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" <sa******@spl.at> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

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

[sam]

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:

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" <sa******@spl.at> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

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

[David W. Fenton]

"sam" <sa******@spl.at> wrote in
news:11**********************@g44g2000cwa.googlegr oups.com:

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

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/

[sam]

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

David W. Fenton wrote:

"sam" <sa******@spl.at> wrote in
news:11**********************@g44g2000cwa.googlegr oups.com:

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

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/

[David W. Fenton]

"sam" <sa******@spl.at> wrote in
news:11**********************@z34g2000cwc.googlegr oups.com:

David W. Fenton wrote:

"sam" <sa******@spl.at> wrote in
news:11**********************@g44g2000cwa.googlegr oups.com:

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

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

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

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/