Hello,

One of our 'clients' needs data in FoxPro readable format. They insist it has to be .dbf file.
I am trying export one table to a new .dbf file. I don't have FoxPro installed on my machine nor Server, but I do see a few FoxPro drivers including MS .dbf driver. I wasn't successful with any of these drivers, usually it asks me to create a new DSN and then I have to pick an existing "FoxPro" database file, not .dbf file. I don't know anything about FoxPro and none of these makes sense to me. If you have any experience DTSing to FoxPro or any other way to get data to .dbf file, please walk me through the steps. I would really appreciate your help.

Thank you.

In news: F1AB2ED1-6FAF-475C-8EBD-CBA6334A18B7...soft (DOT) com,
LP <anonymous (AT) discussions (DOT) microsoft.com> wrote:
Hi Lenny,

I was able to export tables from Pubs with just about every combination of
OLE DB, ODBC, to a DBC and to a free table. Here's the steps I used:

DTS Export data, from Pubs.

OLE DB, OLE DB, DBC
Microsoft OLE DB provider for SQL Server > Microsoft OLE DB provider for
Visual FoxPro, Properties, DBC, choose a DBC I had already created, to DBC >
Copy tables and views > choose Authors > successful - table created in SQL
Server Binn directory.

OLE DB, ODBC, DBC
Microsoft OLE DB provider for SQL Server > Microsoft Visual FoxPro Driver
(ODBC), Properties, DBC, choose a DBC I had already created > Copy tables
and views > choose a data source I already had to a DBC I already created >
choose Discounts, successful - table created in SQL Server Binn directory.

ODBC, ODBC, DBC
Microsoft ODBC Driver for SQL Server > Microsoft Visual FoxPro Driver
(ODBC), System data source, choose a data source I already had to a DBC I
already had > choose DtProperties, successful - table and memo file (DBF and
FTP) created in SQL Server Binn directory.

OLE DB, OLE DB, free tables
Microsoft OLE DB provider for SQL Server > Microsoft OLE DB provider for
Visual FoxPro, Properties, free table directory, choose SQL Server Binn
directory > choose Employee > successful - table created in SQL Server Binn
directory.

OLE DB, ODBC, free tables
Microsoft OLE DB provider for SQL Server > Microsoft Visual FoxPro Driver
(ODBC), Properties, System data source, create a new data source for free
tables, choose sQL Server Binn directory > choose Publishers > successful -
table created in SQL Server Binn directory.

ODBC, ODBC, free tables
Microsoft ODBC Driver for SQL Server > Microsoft Visual FoxPro Driver
(ODBC), System data source, Microsoft ODBC driver for Visual FoxPro, free
table directory, choose SQL Server Binn directory > choose Jobs >
successful - table created in SQL Server Binn directory.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden (AT) mvps (DOT) org www.cindywinegarden.com

Thank you, it worked. But there's still a small problem with Unicode data. Some fields are nvarchar(500) for Unicode data
These fields don not get imported to .dbf correctly. When I query .dbf file with openrowset function, I'm seeing ???? instead of 日精ビ . Any ideas how to make Unicode to go in correctly

Thank fot your help.