Hi, I am fairly new to Access and have a query I was wondering if anybody could answer.

I currently have a txt file and require only relevant data. For example, I have lines

cpntcs0835..........
Lin01
Lin02
Lin03
Lin04
cpnlpl0835............
Lin01
Lin02
cpnptc0835..........
Lin02
Lin04
Cpnptp0835..........
Lin01
Cpnptp0835..........
Lin04

These are different coupons (tcs, lpl, ptp) and each line underneath relates to the coupon and shows what lines have been played for that coupon e.g. the customer has played lin01 & lin02 of cpn lpl, customer has played lin02 & lin04 of cpn type ptc etc.

What I need is a way of running a command button (for example) that will run through the whole table and give me a count of coupon "ptp" which just have "Lin04" assigned to it. In other words how many customers have played the coupon type ptp and have played a Lin04.

Is there a simple solution to this problem??

Thanks

I know you said this was a text file. Given the data structure the way it is, IMO an Access solution isn't what you want. Are you willing and is it possible to restructure the data?

Due to the sheer volume of data, restructuring could be a problem and extremly time consuming. I could always filter the data by "ptp" within access but I would lose all the line info associated with them. Unless of course you can advise other ways??

You can read text files quite easily with the FileSystemObject, specifically the reading mode of the OpenTextFile Method of that object.