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
>