[AccessD] Field Sizes

Does an Access Memo field get converted to VarChar (by default)?

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
dmcafee at pacbell.net

I believe when upsizing, text fields are converted to Char().

The only weird conversion is when dealing with Memo Fields, they become
"text" in SQL :) so don't get the two "text" types confused between SQL &
Access.

I prefer SQL Servers import wizard over Access' Upsize wizard. you can save
the import script and modify the fields if one is converted incorrectly.

D