Access's AutoIncrement field is the same thing as SQL Servers Identity field. Identity fields must be integers. You can specify the 'first number' to use and the 'amount to increment'
Text fields in SQL Server are the same thing as Access's Memo field. It takes 16 bytes to store the 'offset location' where the 'real' data is stored. Instead of using text fields, you really want to use VarChar fields. With a varchar, you can specify the maximum size. VarChar fields cannot be larger than 8000 characters.
-George
Strong and bitter words indicate a weak cause. - Fortune cookie wisdom