vfp dbf to sql server

[Don]

hello,

I'm very new to this. I'm using sql server 2000, I have a
visual fox pro dbf file. I would like to transfer it into sql
server 2000. I tried using the import wizard in sql server,

I've selected:

source data: Microsoft visual fox pro driver.
DSN: selected the visual Fox Pro Database.
even tried creating my own DSN

Result: DTS-Import/Export wizard error:

- Error source:[Microsoft][ODBC Visual Fox Driver]SourceDB
- Context: Error during initialization of the provider.

I've tried to fix the error but I don't know where I've gone
wrong. I was wondering if anyone could give me some tips or advice. Any ideas
would be greatly appreciated.

Thank you
Don

[Fred Taylor]

Try using the upsizing wizard in VFP.

--
Fred


"Don" <donnywong@sympatico.ca> wrote in message
news:3a1bffb3$1@news.devx.com...
>
> hello,
>
> I'm very new to this. I'm using sql server 2000, I have a
> visual fox pro dbf file. I would like to transfer it into sql
> server 2000. I tried using the import wizard in sql server,
>
> I've selected:
>
> source data: Microsoft visual fox pro driver.
> DSN: selected the visual Fox Pro Database.
> even tried creating my own DSN
>
> Result: DTS-Import/Export wizard error:
>
> - Error source:[Microsoft][ODBC Visual Fox Driver]SourceDB
> - Context: Error during initialization of the provider.
>
> I've tried to fix the error but I don't know where I've gone
> wrong. I was wondering if anyone could give me some tips or advice. Any
ideas
> would be greatly appreciated.
>
> Thank you
> Don
>

[Don]

hello Fred,

Thank you for your advice, I really appreciate it. I've tried
a few of the tables already and it seems to work fine. I'm still
looking into it.

Thanks
Don


"Fred Taylor" <ftaylor@qwest.net> wrote:
>Try using the upsizing wizard in VFP.
>
>--
>Fred
>
>
>"Don" <donnywong@sympatico.ca> wrote in message
>news:3a1bffb3$1@news.devx.com...
>>
>> hello,
>>
>> I'm very new to this. I'm using sql server 2000, I have a
>> visual fox pro dbf file. I would like to transfer it into sql
>> server 2000. I tried using the import wizard in sql server,
>>
>> I've selected:
>>
>> source data: Microsoft visual fox pro driver.
>> DSN: selected the visual Fox Pro Database.
>> even tried creating my own DSN
>>
>> Result: DTS-Import/Export wizard error:
>>
>> - Error source:[Microsoft][ODBC Visual Fox Driver]SourceDB
>> - Context: Error during initialization of the provider.
>>
>> I've tried to fix the error but I don't know where I've gone
>> wrong. I was wondering if anyone could give me some tips or advice. Any
>ideas
>> would be greatly appreciated.
>>
>> Thank you
>> Don
>>
>
>