>>> how do i port tables/data from foxpro to the sql/oracle server ?
>>
>>Upsizing to sql-server / oracle ?
>>
>>1. Create a new database.
>>2. Add your old tables (2.5 / 2.6) to it.
>>3. Just choose the upsize wizard, (Tools/Wirards).
>>
>>When using views with parameters you maybe will find the upsizing wizard to sql-server is not perfect.
>>
>>Mark Duitsman.
>
>
>I tried to port tables using your method , but i am facing some difficulties. Firstly if the table contains more than one memo feild and if the memo field is empty, while upsizing it is giving errors and the structure and data is not ported properly .

It should work, I upsized my database some time ago for testing, there are tables in it with more than one memo field and also empty memo fields (most of them are empty).

I will try it again soon to check it out, maybe the memo field has to be set to accept Null values (modi stru in foxpro)?
Are you upsizing to sql-server, and what version are you upsizing to ?

Mark Duitsman