Hello teclioness,

In DTS you should be able to use "Other Connection" and point it at your
Foxpro DSN to do this

Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Hi !

Are you using ODBC or OLE DB. OLE DB is preferable. The latest FoxPro and
Visual FoxPro OLE DB data provider is downloadable from
msdn.microsoft.com/vfoxpro/downloads/updates and it works for all versions
of FoxPro tables.

Set up your linked server as follows:

-- For the @DataSrc value, if your Fox tables are "free" tables (no DBC file
is present in the directory) use only the path to the directory and put
double quotes around it if it has spaces. Something like '"C:\My
Directory\"'
-- If a DBC files is present the @DataSrc value needs to point to the DBC
file as below.

EXEC master.dbo.sp_addlinkedserver
   @server = N'VFP_NORTHWIND',  -- Your linked server name here
   @srvproduct=N'Visual FoxPro 9',  -- can be anything
   @provider=N'VFPOLEDB',
   @datasrc=N'"C:\PROGRAM FILES\MICROSOFT VISUAL FOXPRO
9\Samples\Northwind\Northwind.dbc"',
@provstr=N'VFPOLEDB.1'

-- Then, you can query your tables like:

Select * From YourLinkedServer...YourTable

-- Note 3 dots, and don't use the DBF extension such as YourTable.dbf. Even
if your data source points to a DBC file just use the table name you want to
select from.