>I am trying to import vfp data (from a vfp free table) into an existing SQL Server table
>
>I am trying to use the DTS Wizard in SQL2000. After I choose the Microsoft Visual Foxpro Driver as the data source, and then click next, I get the following error:
>
>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