I don't know if it's possible...
I got a table containing data from a huge unformated txt file (JunkData.txt.). After transfertext and some queries I have eliminated all the text and irrelevant data (tblFormattedData). I got my primary key field (Num AutoNumber). I have deleted a lot of records and i have use queries to find the begining and end of each of the data area inbeded in the text file (tblStart/EndMarker). And I have a specific value extracted within the text file (tblTimeValue).
Then the hard part is that I need to match each record of the data area with a specific record from tblTimeValue. Then repeat the operation for the next data area for the next record from tblTimeValue.
Also the file has let say around 250 data areas each having about 450 records.
Any help would be appreciated
Thanks
JT
I got a table containing data from a huge unformated txt file (JunkData.txt.). After transfertext and some queries I have eliminated all the text and irrelevant data (tblFormattedData). I got my primary key field (Num AutoNumber). I have deleted a lot of records and i have use queries to find the begining and end of each of the data area inbeded in the text file (tblStart/EndMarker). And I have a specific value extracted within the text file (tblTimeValue).
Then the hard part is that I need to match each record of the data area with a specific record from tblTimeValue. Then repeat the operation for the next data area for the next record from tblTimeValue.
Also the file has let say around 250 data areas each having about 450 records.
Any help would be appreciated
Thanks
JT
