In analyzing a large flat table that will be built into a new database that will be relational I'd like to write code that will do the following, if it is possible. 1. Max length of text values in all fields, drop them in a new table. lastname 33 firstname 27 etc 2. Unique values for all fields, output each field and values in a new tables. I'd like to have that output like this: tbl_Ethnicity AfAm AfrAmerican Af-Amer etc tbl_PhoneType Home Alt Alternate Current WFax WorkFax etc Knowing these things will help me create my new table structure and determine what values I'll need in lookup tables.