Hi Dmitry,

I successfully exported pubs.dbo.authors to a vfp table using DTS Export wizard. I had to add destination path to the table name in the CREATE TABLE statement to make sure that table is created in the correct directory. Can you do that on your PC as a test?

>No matter what I try, I am having a problem with Exporting data from a couple of table in SQL to VFP. At the end of the Export it shows Create Table error but when you click on the error line, error messagebox appears empty. But I suspect that the problem has something to do with field type/length/name/whatever.
>
>In the Select Source Tables and Views I go to Transform and tried to exclude all fields but one (just to simplify) but I am still getting the error. BTW, the way I try to exclude a column from transfer is by changing Destination to .
>
>Any other idea/suggestions on what I should do?
>

--sb--