Andrus,

For a VFP date I'd use datetime in SQL. The smalldatetime type in SQL doesn't equate very well with the range covered by a VFP date field.

For logical you have choices of bit, tinyint, char(1)

>I thought that there must be some ready-made code for this. upsizing wizard
>code seems to be too complicated.
>
>I have no idea how to convert VFP Logical and DATE field types to/from SQL server.