Combine two unretlated linked tables

[jfmalone]

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???

 

[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]

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

 

[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]

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

 

[Galen Scott]

..

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

 

[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]

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

 

[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