Hey there,
I have multiple .txt files with columns that are separated by the character "|". I know I can import these delimited and separate them so that they appear in the access database, but that is only a part of what I'm trying to do.
All of the text files share a "report key" and using this report key, I want to link the .txt files into one table so that I can see the information for each report key consecutively, rather than having to look it up multiple times in different tables...
So once again, I know that I can do this by simply importing one table, then adding the rest of my imported tables to the initial table I create....HOWEVER, in one of the .txt files, I have some rows that share the same report key because there are multiple entries for one report key.
My issue is that I need to match all that data, so it can be easily viewed and searched for, can somebody please help me? I've been trying to do this for a very long time.
So I have A.txt B.txt and C.txt
Lets say A gives me an event that occurred, B gives me what it caused, and C gives me why it happened....
For C, I have multiple reasons for why the report key in A and B happened.
How can I make it so that I can see one report key, then see the information A,B, and C all at one place?