Welcome to SPN

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

Sign Up Now!

Combine two unretlated linked tables

Discussion in 'Information Technology' started by jfmalone@hotmail.com, Jul 28, 2006.

  1. jfmalone@hotmail.com

    jfmalone@hotmail.com
    Expand Collapse
    Guest

    I have two unrelated (no common information) link tables going back to
    txt files. Table one contains two coulmns, client and project. Table
    two has three columns, date, printer, paper size. Line one of each
    tables was created from a single printing. Same for line two, three,
    ect.

    I would like to combine these two into one table which will update as
    the txt file is updated. This will allow us to track our plotting much
    better than our current honour system.

    Any help???
     
  2. Loading...

    Similar Threads Forum Date
    SciTech New Quantum Dot Technique Combines Best of Optical and Electron Microscopy Breaking News Jun 17, 2013
    SAD-Sant Samaj Combine Sweeps SGPC Elections Sikh Sikhi Sikhism Sep 19, 2011
    SciTech 3,000 images combine for Milky Way portrait Breaking News Nov 2, 2009
    Sikh News SAD-BJP combine sweeps civic polls in Punjab (Outlook India) Breaking News Aug 8, 2007

  3. Sheila D

    Sheila D
    Expand Collapse
    Guest

    If there is no common information it seems a little illogical to put all the
    information in 1 table. Can you explain why you want to do this?

    Sheila
    www.c-i-m-s.com
    "jfmalone@hotmail.com" wrote:

    > I have two unrelated (no common information) link tables going back to
    > txt files. Table one contains two coulmns, client and project. Table
    > two has three columns, date, printer, paper size. Line one of each
    > tables was created from a single printing. Same for line two, three,
    > ect.
    >
    > I would like to combine these two into one table which will update as
    > the txt file is updated. This will allow us to track our plotting much
    > better than our current honour system.
    >
    > Any help???
    >
    >
     
  4. jfmalone@hotmail.com

    jfmalone@hotmail.com
    Expand Collapse
    Guest

    When we plot drawings a txt file is created, one with the project and
    client and another with the printer, paper, and date. If we can
    combine the two, we can quickly generate a report to track our
    printing.

    Like I said, each row of each txt file is created at the same time. So
    this is the basic result:

    txt file one txt file two
    Mr Smith, house extension 04/07/06, HP850, A2
    Mr Jones, planning study 05/07/06, HP A4 Laserjet, A4
    Mr Smith, house extension 05/07/06, HP A4 Laserjet, A4
    Mrs Brown, loft conversion 07/07/06, HP850, A2

    If the information could be put into one table, with the each row
    containing all five bit of information we could track the info.

    Thanks
    Joe

    Sheila D wrote:
    > If there is no common information it seems a little illogical to put all the
    > information in 1 table. Can you explain why you want to do this?
    >
    > Sheila
    > www.c-i-m-s.com
    > "jfmalone@hotmail.com" wrote:
    >
    > > I have two unrelated (no common information) link tables going back to
    > > txt files. Table one contains two coulmns, client and project. Table
    > > two has three columns, date, printer, paper size. Line one of each
    > > tables was created from a single printing. Same for line two, three,
    > > ect.
    > >
    > > I would like to combine these two into one table which will update as
    > > the txt file is updated. This will allow us to track our plotting much
    > > better than our current honour system.
    > >
    > > Any help???
    > >
    > >
     
  5. Sheila D

    Sheila D
    Expand Collapse
    Guest

    In your text files is there anything at all that Acces can use to link the 2
    together - maybe a line or record number that is the same for both? Or can
    you add line numbers which are the same in both files - if so Access can link
    on that number. Otherwise I think your only option is to edit whatever
    creates the Text file and combine the info there (but maybe someone else can
    think of something...) Sorry can't be more helpful but Access can't link non
    related data.

    Sheila
    www.c-i-m-s.com
    "jfmalone@hotmail.com" wrote:

    > When we plot drawings a txt file is created, one with the project and
    > client and another with the printer, paper, and date. If we can
    > combine the two, we can quickly generate a report to track our
    > printing.
    >
    > Like I said, each row of each txt file is created at the same time. So
    > this is the basic result:
    >
    > txt file one txt file two
    > Mr Smith, house extension 04/07/06, HP850, A2
    > Mr Jones, planning study 05/07/06, HP A4 Laserjet, A4
    > Mr Smith, house extension 05/07/06, HP A4 Laserjet, A4
    > Mrs Brown, loft conversion 07/07/06, HP850, A2
    >
    > If the information could be put into one table, with the each row
    > containing all five bit of information we could track the info.
    >
    > Thanks
    > Joe
    >
    > Sheila D wrote:
    > > If there is no common information it seems a little illogical to put all the
    > > information in 1 table. Can you explain why you want to do this?
    > >
    > > Sheila
    > > www.c-i-m-s.com
    > > "jfmalone@hotmail.com" wrote:
    > >
    > > > I have two unrelated (no common information) link tables going back to
    > > > txt files. Table one contains two coulmns, client and project. Table
    > > > two has three columns, date, printer, paper size. Line one of each
    > > > tables was created from a single printing. Same for line two, three,
    > > > ect.
    > > >
    > > > I would like to combine these two into one table which will update as
    > > > the txt file is updated. This will allow us to track our plotting much
    > > > better than our current honour system.
    > > >
    > > > Any help???
    > > >
    > > >

    >
    >
     
  6. jfmalone@hotmail.com

    jfmalone@hotmail.com
    Expand Collapse
    Guest

    Ok, I have managed to have the printing generate a single hypen in
    each txt file. So now I get

    txt file one txt file two
    Mr Smith, house extension, - 04/07/06, HP850, A2, -

    What next? Is this enough to merge the two?

    Thanks for the tip


    Sheila D wrote:
    > In your text files is there anything at all that Acces can use to link the 2
    > together - maybe a line or record number that is the same for both? Or can
    > you add line numbers which are the same in both files - if so Access can link
    > on that number. Otherwise I think your only option is to edit whatever
    > creates the Text file and combine the info there (but maybe someone else can
    > think of something...) Sorry can't be more helpful but Access can't link non
    > related data.
    >
    > Sheila
    > www.c-i-m-s.com
    > "jfmalone@hotmail.com" wrote:
    >
    > > When we plot drawings a txt file is created, one with the project and
    > > client and another with the printer, paper, and date. If we can
    > > combine the two, we can quickly generate a report to track our
    > > printing.
    > >
    > > Like I said, each row of each txt file is created at the same time. So
    > > this is the basic result:
    > >
    > > txt file one txt file two
    > > Mr Smith, house extension 04/07/06, HP850, A2
    > > Mr Jones, planning study 05/07/06, HP A4 Laserjet, A4
    > > Mr Smith, house extension 05/07/06, HP A4 Laserjet, A4
    > > Mrs Brown, loft conversion 07/07/06, HP850, A2
    > >
    > > If the information could be put into one table, with the each row
    > > containing all five bit of information we could track the info.
    > >
    > > Thanks
    > > Joe
    > >
    > > Sheila D wrote:
    > > > If there is no common information it seems a little illogical to put all the
    > > > information in 1 table. Can you explain why you want to do this?
    > > >
    > > > Sheila
    > > > www.c-i-m-s.com
    > > > "jfmalone@hotmail.com" wrote:
    > > >
    > > > > I have two unrelated (no common information) link tables going back to
    > > > > txt files. Table one contains two coulmns, client and project. Table
    > > > > two has three columns, date, printer, paper size. Line one of each
    > > > > tables was created from a single printing. Same for line two, three,
    > > > > ect.
    > > > >
    > > > > I would like to combine these two into one table which will update as
    > > > > the txt file is updated. This will allow us to track our plotting much
    > > > > better than our current honour system.
    > > > >
    > > > > Any help???
    > > > >
    > > > >

    > >
    > >
     
  7. Galen Scott

    Galen Scott
    Expand Collapse
    Guest

    ..


    In article 1152185339.985883.252590@m73g2000cwd.googlegroups.com,
    "jfmalone@hotmail.com" <jfmalone@hotmail.com> wrote on 7/6/06 6:29 AM:

    > When we plot drawings a txt file is created, one with the project and
    > client and another with the printer, paper, and date. If we can
    > combine the two, we can quickly generate a report to track our
    > printing.
    >
    > Like I said, each row of each txt file is created at the same time. So
    > this is the basic result:
    >
    > txt file one txt file two
    > Mr Smith, house extension 04/07/06, HP850, A2
    > Mr Jones, planning study 05/07/06, HP A4 Laserjet, A4
    > Mr Smith, house extension 05/07/06, HP A4 Laserjet, A4
    > Mrs Brown, loft conversion 07/07/06, HP850, A2
    >
    > If the information could be put into one table, with the each row
    > containing all five bit of information we could track the info.
    >
    > Thanks
    > Joe
    >
    > Sheila D wrote:
    >> If there is no common information it seems a little illogical to put all the
    >> information in 1 table. Can you explain why you want to do this?
    >>
    >> Sheila
    >> www.c-i-m-s.com
    >> "jfmalone@hotmail.com" wrote:
    >>
    >>> I have two unrelated (no common information) link tables going back to
    >>> txt files. Table one contains two coulmns, client and project. Table
    >>> two has three columns, date, printer, paper size. Line one of each
    >>> tables was created from a single printing. Same for line two, three,
    >>> ect.
    >>>
    >>> I would like to combine these two into one table which will update as
    >>> the txt file is updated. This will allow us to track our plotting much
    >>> better than our current honour system.
    >>>
    >>> Any help???
    >>>
    >>>

    >
     
  8. Sheila D

    Sheila D
    Expand Collapse
    Guest

    Hi Joe

    What you need ia a unique reference for each record so say you have 20
    different print records in each text file you need numbers 1 - 20 (for
    example) to uniquely identify each one - can you do that?

    If so, then you can use thw File menu to import or link in Access and set a
    relationship between the tables using that key piece of information. It won't
    work if you have the same reference - your hyphen - for each one

    Sheila
    www.c-i-m-s.com

    "jfmalone@hotmail.com" wrote:

    > Ok, I have managed to have the printing generate a single hypen in
    > each txt file. So now I get
    >
    > txt file one txt file two
    > Mr Smith, house extension, - 04/07/06, HP850, A2, -
    >
    > What next? Is this enough to merge the two?
    >
    > Thanks for the tip
    >
    >
    > Sheila D wrote:
    > > In your text files is there anything at all that Acces can use to link the 2
    > > together - maybe a line or record number that is the same for both? Or can
    > > you add line numbers which are the same in both files - if so Access can link
    > > on that number. Otherwise I think your only option is to edit whatever
    > > creates the Text file and combine the info there (but maybe someone else can
    > > think of something...) Sorry can't be more helpful but Access can't link non
    > > related data.
    > >
    > > Sheila
    > > www.c-i-m-s.com
    > > "jfmalone@hotmail.com" wrote:
    > >
    > > > When we plot drawings a txt file is created, one with the project and
    > > > client and another with the printer, paper, and date. If we can
    > > > combine the two, we can quickly generate a report to track our
    > > > printing.
    > > >
    > > > Like I said, each row of each txt file is created at the same time. So
    > > > this is the basic result:
    > > >
    > > > txt file one txt file two
    > > > Mr Smith, house extension 04/07/06, HP850, A2
    > > > Mr Jones, planning study 05/07/06, HP A4 Laserjet, A4
    > > > Mr Smith, house extension 05/07/06, HP A4 Laserjet, A4
    > > > Mrs Brown, loft conversion 07/07/06, HP850, A2
    > > >
    > > > If the information could be put into one table, with the each row
    > > > containing all five bit of information we could track the info.
    > > >
    > > > Thanks
    > > > Joe
    > > >
    > > > Sheila D wrote:
    > > > > If there is no common information it seems a little illogical to put all the
    > > > > information in 1 table. Can you explain why you want to do this?
    > > > >
    > > > > Sheila
    > > > > www.c-i-m-s.com
    > > > > "jfmalone@hotmail.com" wrote:
    > > > >
    > > > > > I have two unrelated (no common information) link tables going back to
    > > > > > txt files. Table one contains two coulmns, client and project. Table
    > > > > > two has three columns, date, printer, paper size. Line one of each
    > > > > > tables was created from a single printing. Same for line two, three,
    > > > > > ect.
    > > > > >
    > > > > > I would like to combine these two into one table which will update as
    > > > > > the txt file is updated. This will allow us to track our plotting much
    > > > > > better than our current honour system.
    > > > > >
    > > > > > Any help???
    > > > > >
    > > > > >
    > > >
    > > >

    >
    >
     
  9. jfmalone@hotmail.com

    jfmalone@hotmail.com
    Expand Collapse
    Guest

    No, I can't. I gues I'll have to sort it out via a different route. I
    can improt the data into excel as I want, it just isn't as easy to do
    the reports.

    Thanks for all the help

    Sheila D wrote:
    > Hi Joe
    >
    > What you need ia a unique reference for each record so say you have 20
    > different print records in each text file you need numbers 1 - 20 (for
    > example) to uniquely identify each one - can you do that?
    >
    > If so, then you can use thw File menu to import or link in Access and set a
    > relationship between the tables using that key piece of information. It won't
    > work if you have the same reference - your hyphen - for each one
    >
    > Sheila
    > www.c-i-m-s.com
    >
    > "jfmalone@hotmail.com" wrote:
    >
    > > Ok, I have managed to have the printing generate a single hypen in
    > > each txt file. So now I get
    > >
    > > txt file one txt file two
    > > Mr Smith, house extension, - 04/07/06, HP850, A2, -
    > >
    > > What next? Is this enough to merge the two?
    > >
    > > Thanks for the tip
    > >
    > >
    > > Sheila D wrote:
    > > > In your text files is there anything at all that Acces can use to link the 2
    > > > together - maybe a line or record number that is the same for both? Or can
    > > > you add line numbers which are the same in both files - if so Access can link
    > > > on that number. Otherwise I think your only option is to edit whatever
    > > > creates the Text file and combine the info there (but maybe someone else can
    > > > think of something...) Sorry can't be more helpful but Access can't link non
    > > > related data.
    > > >
    > > > Sheila
    > > > www.c-i-m-s.com
    > > > "jfmalone@hotmail.com" wrote:
    > > >
    > > > > When we plot drawings a txt file is created, one with the project and
    > > > > client and another with the printer, paper, and date. If we can
    > > > > combine the two, we can quickly generate a report to track our
    > > > > printing.
    > > > >
    > > > > Like I said, each row of each txt file is created at the same time. So
    > > > > this is the basic result:
    > > > >
    > > > > txt file one txt file two
    > > > > Mr Smith, house extension 04/07/06, HP850, A2
    > > > > Mr Jones, planning study 05/07/06, HP A4 Laserjet, A4
    > > > > Mr Smith, house extension 05/07/06, HP A4 Laserjet, A4
    > > > > Mrs Brown, loft conversion 07/07/06, HP850, A2
    > > > >
    > > > > If the information could be put into one table, with the each row
    > > > > containing all five bit of information we could track the info.
    > > > >
    > > > > Thanks
    > > > > Joe
    > > > >
    > > > > Sheila D wrote:
    > > > > > If there is no common information it seems a little illogical to put all the
    > > > > > information in 1 table. Can you explain why you want to do this?
    > > > > >
    > > > > > Sheila
    > > > > > www.c-i-m-s.com
    > > > > > "jfmalone@hotmail.com" wrote:
    > > > > >
    > > > > > > I have two unrelated (no common information) link tables going back to
    > > > > > > txt files. Table one contains two coulmns, client and project. Table
    > > > > > > two has three columns, date, printer, paper size. Line one of each
    > > > > > > tables was created from a single printing. Same for line two, three,
    > > > > > > ect.
    > > > > > >
    > > > > > > I would like to combine these two into one table which will update as
    > > > > > > the txt file is updated. This will allow us to track our plotting much
    > > > > > > better than our current honour system.
    > > > > > >
    > > > > > > Any help???
    > > > > > >
    > > > > > >
    > > > >
    > > > >

    > >
    > >
     
  10. Sheila D

    Sheila D
    Expand Collapse
    Guest

    Joe - if you can get it into Excel then you can link or import the Excel
    worksheet to Access. Just make sure you have a column heading for each piece
    of data and then use the File, Get External Data command in Access. Then you
    can create your reports in Access. Good Luck

    Sheila
    www.c-i-m-s.com
    MS training & consultancy - London

    "jfmalone@hotmail.com" wrote:

    > No, I can't. I gues I'll have to sort it out via a different route. I
    > can improt the data into excel as I want, it just isn't as easy to do
    > the reports.
    >
    > Thanks for all the help
    >
    > Sheila D wrote:
    > > Hi Joe
    > >
    > > What you need ia a unique reference for each record so say you have 20
    > > different print records in each text file you need numbers 1 - 20 (for
    > > example) to uniquely identify each one - can you do that?
    > >
    > > If so, then you can use thw File menu to import or link in Access and set a
    > > relationship between the tables using that key piece of information. It won't
    > > work if you have the same reference - your hyphen - for each one
    > >
    > > Sheila
    > > www.c-i-m-s.com
    > >
    > > "jfmalone@hotmail.com" wrote:
    > >
    > > > Ok, I have managed to have the printing generate a single hypen in
    > > > each txt file. So now I get
    > > >
    > > > txt file one txt file two
    > > > Mr Smith, house extension, - 04/07/06, HP850, A2, -
    > > >
    > > > What next? Is this enough to merge the two?
    > > >
    > > > Thanks for the tip
    > > >
    > > >
    > > > Sheila D wrote:
    > > > > In your text files is there anything at all that Acces can use to link the 2
    > > > > together - maybe a line or record number that is the same for both? Or can
    > > > > you add line numbers which are the same in both files - if so Access can link
    > > > > on that number. Otherwise I think your only option is to edit whatever
    > > > > creates the Text file and combine the info there (but maybe someone else can
    > > > > think of something...) Sorry can't be more helpful but Access can't link non
    > > > > related data.
    > > > >
    > > > > Sheila
    > > > > www.c-i-m-s.com
    > > > > "jfmalone@hotmail.com" wrote:
    > > > >
    > > > > > When we plot drawings a txt file is created, one with the project and
    > > > > > client and another with the printer, paper, and date. If we can
    > > > > > combine the two, we can quickly generate a report to track our
    > > > > > printing.
    > > > > >
    > > > > > Like I said, each row of each txt file is created at the same time. So
    > > > > > this is the basic result:
    > > > > >
    > > > > > txt file one txt file two
    > > > > > Mr Smith, house extension 04/07/06, HP850, A2
    > > > > > Mr Jones, planning study 05/07/06, HP A4 Laserjet, A4
    > > > > > Mr Smith, house extension 05/07/06, HP A4 Laserjet, A4
    > > > > > Mrs Brown, loft conversion 07/07/06, HP850, A2
    > > > > >
    > > > > > If the information could be put into one table, with the each row
    > > > > > containing all five bit of information we could track the info.
    > > > > >
    > > > > > Thanks
    > > > > > Joe
    > > > > >
    > > > > > Sheila D wrote:
    > > > > > > If there is no common information it seems a little illogical to put all the
    > > > > > > information in 1 table. Can you explain why you want to do this?
    > > > > > >
    > > > > > > Sheila
    > > > > > > www.c-i-m-s.com
    > > > > > > "jfmalone@hotmail.com" wrote:
    > > > > > >
    > > > > > > > I have two unrelated (no common information) link tables going back to
    > > > > > > > txt files. Table one contains two coulmns, client and project. Table
    > > > > > > > two has three columns, date, printer, paper size. Line one of each
    > > > > > > > tables was created from a single printing. Same for line two, three,
    > > > > > > > ect.
    > > > > > > >
    > > > > > > > I would like to combine these two into one table which will update as
    > > > > > > > the txt file is updated. This will allow us to track our plotting much
    > > > > > > > better than our current honour system.
    > > > > > > >
    > > > > > > > Any help???
    > > > > > > >
    > > > > > > >
    > > > > >
    > > > > >
    > > >
    > > >

    >
    >
     

Share This Page