>HI,
>
>I need to create a connection to Visual Foxpro DBC database for query specific table documentos and insert the result into Cursor for creating a new table on SQL server to insert the result of my cursor.
>This is my code:

Luís,

Why don't you just OPEN DATABASE and SELECT FROM whatever you need to extract, and INSERT whatever you need to add?

Hi Antonio,

Thanks for your reply.
My program is developed in VFP9 with a SQL Server database, so I can create a routine to connect to my client's old FoxPro database.
to pass data to my program, namely SQL Server, because my client's software is specifically for glassware.

My problem is that I can't open the database from the client's software, I just need to collect the data from the invoice head table and the invoice line table from my programme.
The USE command of the table lock it, so I can't use this option or the other software will stop.

Ideally, I'd like to be able to connect to the DBC database via ODBC and perform the necessary queries to pass the data to a cursor in VFP and make INSERTs in my SQL table.


Are there any of these possibilities?
Thank you
Luis