By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,611 Members | 1,377 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,611 IT Pros & Developers. It's quick & easy.

INSERT INTO Acess 2K table from Visual FoxPro DBF

P: n/a
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

Feb 22 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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

Feb 22 '06 #2

P: n/a
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


Feb 22 '06 #3

P: n/a
"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/
Feb 23 '06 #4

P: n/a
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/


Feb 23 '06 #5

P: n/a
"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/
Feb 23 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.