Hello:

>Is there any easy and quick way to import FoxPro .dbfs data into a FireBird .fdb?
>

Huummm .... using Visual Foxpro remote views for the Firebird
database and APPEND FROM should be easy.

You can check the Interbase Datapump too:

http://www.clevercomponents.com/products/datapump/ibdatapump.asp

>The FoxPro .dbfs will contain lots of memo fields with unknown text lengths of clients correspondences, which include embedded carriage returns and line feeds.
>
>I am aware of varchar in FireBird but it still requires a length to be
>specified for the field, what type is there in FireBird to allow (well
>almost <g>) perpetual text content lengths.
>

Use a text blob (blob sub_type text)




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain