Hi Sergey,
When you were exporting the tables to vfp did you choose Microsoft OLE DB Provider for Visual Foxpro or Microsoft Foxpro VFP Driver(*.dbf)?

>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?
>>

"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham