Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2012
    Posts
    2

    Unanswered: Append multiple Lookup tables with one data table

    I have the following 30 Lookup tables that would need only two records "T" and "F".
    The data file tmptablefordata has only one field "TF" with two records T and F.

    I would like to be able to append all these 30 lookup tables at once with the data table tmptablefordata.
    Any advice would be appreciated. Thank you.

    tblone (fieldnames: one oneid)
    tbltwo (fieldnames: two twoid)
    tblthree (fieldnames: three threeid)
    .
    .
    tbltwentyeight (fieldnames: twentyeight twentyeightid)
    tbltwentynine (fieldnames: twentynine twentynineid)
    tblthirty (fieldnames: thirty thirtyid)


    tmptablefordata (fieldnames: TF ID)
    Last edited by vbauser; 02-18-12 at 03:11.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •