Hi,
I am fairly new to access please help. I have a report from another data system that is a text file that I paste into a table then I have a query sort the information out. In the text file there is a header with information that I could use and make other tables work better but I need to have a piece of information from the header be attached to the lines of text directly below.
So, how do I take that header information and put it with a varied amount of line text below.
example txt
header 1234 someinformationthatIneedtouse
4566655 jon smith 12/11/2012
6545666 dave jones 12/13/2012
header 1783 someinformationthatIneedtouse
2333333 sammy davis 12/23/2012
.....
I am looking for the data to show up in the table like so
1234 4566655 jon smith 12/11/2012
1234 6545666 dave jones 12/13/2012
1783 2333333 sammy davis 12/23/2012
Thanks
I am fairly new to access please help. I have a report from another data system that is a text file that I paste into a table then I have a query sort the information out. In the text file there is a header with information that I could use and make other tables work better but I need to have a piece of information from the header be attached to the lines of text directly below.
So, how do I take that header information and put it with a varied amount of line text below.
example txt
header 1234 someinformationthatIneedtouse
4566655 jon smith 12/11/2012
6545666 dave jones 12/13/2012
header 1783 someinformationthatIneedtouse
2333333 sammy davis 12/23/2012
.....
I am looking for the data to show up in the table like so
1234 4566655 jon smith 12/11/2012
1234 6545666 dave jones 12/13/2012
1783 2333333 sammy davis 12/23/2012
Thanks