>We are faced with moving an app from local tables to MS SQL Server. Several of the tables have memo fields, some of which reach 1000 characters. Question: what does the wizard do with these memo fields? TIA.

Without looking it up, I'm pretty sure it turns them into SQL's TEXT datatype. Depending on how much data you have, the Upsizing Wizard may take a while, but you should be able to get your memo fields there OK.

HTH,
Scot.