Hi all!

I have a link to VFP data that I made using the sp_AddLinkedServer stored procedure, like this:

sp_addlinkedserver @server='VFPData', @srvproduct='', @Provider='MSDASQL',
@provstr='DRIVER={Microsoft Visual FoxPro Driver};Deleted=Yes;Exclusive=No;SourceType=DBF;SourceDB=\\Server\Share\dir\'

Next, I can access my table using:

select * from openquery(VFPData, 'SELECT * FROM TableName')

Excellent!

Now, what if I want to update, insert or delete? In theory, I could use server.schema.owner.table, but what is the schema and owner of VFP data?

Thanks!