I have a txt file that I want to import into either Access or Excel.
The format has the date and client name on one line, then several lines of data that are in fixed format.
Each client has a different number of records.
Any Ideas how I can automate bringing this data into Excel or Access, so that I have the client name on each row of data?
thanks
