I am unable to use the SQL Server 7 (Eval Edition) DTS (Data Trans. Svc) Import Wizard to import VFP tables. On the first DTS form, for the Source prompt I select 'Microsoft VFP Driver' from the listbox, for the User/System DSN prompt I select 'VFP Tables' from the listbox, (if I skip the User/System DSN prompt, I select 'VFP tables (not sharable).dsn' for the File DSN prompt). I do not enter anything for the user/password prompts. When I click on the Next button I get the following error msg. 'Error Source:Microsoft OLE DB provider for ODBC driver. Error Desc:[Microsoft][ODBC VFP Driver] Source DB
Any ideas?
Mark Achin
Independent Consultant, VFP MCP