>>I am still getting errors but I think it is due to the structure of the SQL Server table I am trying to export. Some tables it works, others I get error.
>>I need to change the field names to make sure they are all unique.
>>
>You should be able to preserve field names if you export to VFP tables in DBC.
I tried to export to DBC but had the same problem. I created a database without tables and I thought that the Export Wizard will add tables to the DBC. But it didn't work. So I am working with free tables now. I will try to use a DTS package, as you suggested in another message.
Thank you so much for your help.
BTW, the only way, so far, I was able to export these tables is by selecting dBase III driver. Which will lead me to the right destination. But I am just curious (or stubborn <g>) to find out the correct approach.
"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