>>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
Sounds like a missing Set Exclusive Off before the Use.