Hi Venelina,
I updated the MDAC to 2.7 and I installed Visual Studio Service Pack 5 - I am on VfP 6 - it still didn't work. Someone else told me I need to use the VFP Ole DB Provider that comes with VFP 7 - so I installed VFP 7 and retried with the VFP Ole DB Provider. Now I am getting a different set of errors. I will post again when I am more clear on the errors.
Thanks for your help.
>>
>>DTS Import/Export Wizard Error
>>
>>Error Source: Microsoft OLE DB Provider for ODBC Drivers
>>
>>Error Description: [Microsoft] [ODBC VISUAL Foxpro Driver]SourceDB
>>
>>Context: Error during initialization of the provider
>>
>>Is this a bug, or am I doing something wrong?
>>
>>TIA
>What kind of MDAC you use? Will be nice to install latest one - MDAC2.7 from
http://www.microsoft.com/data/download.htm and try again