RE: Inserting into FoxPro via ODBC
From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 11/04/04
- Next message: Kevin Yu [MSFT]: "RE: Can't connect to SQL Server 2000"
- Previous message: adamspencer2004: "Visaul Basic 6.0 will connect to Access 2000 DB?"
- In reply to: LisaConsult: "Inserting into FoxPro via ODBC"
- Next in thread: Cindy Winegarden: "Re: Inserting into FoxPro via ODBC"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 04 Nov 2004 05:49:20 GMT
Hi,
First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to insert certain rows from
free table A to free table B in a Foxpro database using ado. If there is
any misunderstanding, please feel free to let me know.
Based on the "Syntax error" message, it seems that SELECT clause in the
INSERT INTO statement is not supported by Foxpro ODBC driver, although it
is supported in Visual Foxpro.
So I suggest you find a place to store data from Table A and then insert
them into Table B. Or it's better to use Access or SQL server to do this,
because it would be much more convenient.
HTH.
Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
- Next message: Kevin Yu [MSFT]: "RE: Can't connect to SQL Server 2000"
- Previous message: adamspencer2004: "Visaul Basic 6.0 will connect to Access 2000 DB?"
- In reply to: LisaConsult: "Inserting into FoxPro via ODBC"
- Next in thread: Cindy Winegarden: "Re: Inserting into FoxPro via ODBC"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
