Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Max length of text values in all fields, Unique values for all fields

Discussion in 'Information Technology' started by tcb, Jul 28, 2006.

  1. tcb

    tcb
    Expand Collapse
    Guest

    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.
     
  2. Loading...

    Similar Threads Forum Date
    General Max Arthur Macauliffe History of Sikhism Sep 4, 2013
    SciTech Mammals pick offspring’s sex to maximize number of grandchildren, study shows Breaking News Jul 11, 2013
    Events Year 2013 is centennial to honour max arthur macauliffe History of Sikhism May 8, 2013
    Sikhi To The Max developers Information Technology Mar 26, 2013
    NRI brides from region face max desertions Hard Talk Jan 22, 2010

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    You can see how to loop through all the Fields in a table, listing their
    names types, sizes, and descriptions here:
    http://allenbrowne.com/func-06.html

    To add them to a table, OpenRecordset, and AddNew with Update.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "tcb" <tbenson@mn.rr.com> wrote in message
    news:1149768045.324798.236720@y43g2000cwc.googlegroups.com...
    > 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.
     

Share This Page