Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Denormilize a Table? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    Looking for some DAO code to accomplish the following.

    Thanks, John

    =============

    I have the following unstructed file in an access table Quicken_Input (almost like reading punched paper tape in the old days)

    I have to denormalize it into Quicken_Denormalized taking the 6 fields/records in Quicken_Input and create 1 record in Quicken_Denormalized

    There are 2 blank records at the beginig of the file

    !Type:Bank record signals start of file

    Each transaction is made up of 6 records each prefixed with 1 alpha character identifier D, T, C, N, P, & M

    Each transaction ends with a ^

    <pre>Quicken_Input -------------------------------
    Blank line
    Blank line
    !Type:Bank (start of bank)
    D10/25/2005 (D = date first transaction)
    T-300.00 (T = amount first transaction)
    C* (C = Cleared first transaction)
    N244 (N = Check number first transaction)
    PCheck Nbr: 244 (P = Payee/Description first transaction)
    MRent (M = Memo first transaction)
    ^ (End of first transaction)
    D10/25/2005 (date second transaction)
    T-175.00 (amount second transaction)
    C* (Cleared second transaction)
    N642 (Check number second transaction)
    PCheck Nbr: 642 (Payee/Description second transaction)
    MElectric (Memo second transaction)
    ^ (End of second transaction)
    D10/25/2005 (etc)
    T-175.00
    C*
    N634
    PCheck Nbr: 634
    MTelephone
    ^ (End of file)
    </pre>


  2. #2
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Denormilize a Table? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    Hi Hans

    The code worked great, for others that may be following there was a typo you may want to correct

    Thank you very much

    John

    Case "P"
    rstOut!strDescription = strValue
    If Not strValue = "" Then
    End If

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Denormilize a Table? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    I'd say that Quicken_Input is already plenty denormalized, and that you want to (partially) normalize the structure, not denormalize. So I'd rename the other table Quicken_Normalized. You can use the code in the attached text file (copy into a standard module).

    Error in attachment corrected.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Denormilize a Table? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    Thanks, I have cirrected the error in the attachment.

Posting Permissions

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