Disclaimer:
I have not worked with Foxpro DB. However, if you can open the dBase files in MS ACCESS, then this solution might work.
You can put all your dBase files in a folder and define a Linked Server in you SQL Server instance. An example:
EXEC sp_addlinkedserver
'myDbaseDB',
'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'C:\kaushal\dBaseFILES',
NULL,
'dBase IV'
GO
.. then define a login information for the newly defined linked server ...
exec sp_addlinkedsrvlogin
@rmtsrvname = 'myDbaseDB',
@useself = false,
@locallogin = NULL,
@rmtuser = NULL,
@rmtpassword = NULL
GO
And you are good to go.. Let's say you have a dBase file called ORDERS.dbf , you should be able to run a query like this:
select * from openquery(myDbaseDB, 'select * from ORDERS')