At this stage of my exploration I'm using sql server express, no ssis package there. No biggie. I'll walk another path.

Many thanks.

>If you're using SQL Server 2008 64 bit, the only way to get data from VFP or to VFP from SQL Server is to use SSIS package.
>
>See this blog post explaining all the steps:
>
>Working with 32 bit providers and 64 bit SQL Server
>
>
>>The fact that I get :
>>
>>"Could not locate registry entry for OLE DB provider 'VFPOLEDB.1'."
>>
>>when I execute this sqlserver express r8:
>>
>>

>>select * from openrowset ('VFPOLEDB.1', 'c:\data\plucz\plucz.dbc'; ' '; ' ','select * from polished')
>>go
>>

>>
>>is a 64bit issue right? No point in exploring this any further, is what I'm really asking.
>>
>>From about in management studio:
>>

>>Microsoft SQL Server Management Studio						10.50.1600.1
>>Microsoft Data Access Components (MDAC)						6.1.7600.16385
>>Microsoft MSXML						3.0 4.0 5.0 6.0 
>>Microsoft Internet Explorer						8.0.7600.16385
>>Microsoft .NET Framework						2.0.50727.4963
>>Operating System						6.1.7600
>>