Import multi header text files?

[theta]

Hi. Anybody got any good software for importing multi header text file into excel or access. Found one solution but looking for more (add-in, or FREEWARE)

http://www.beside.com/sample2.html

thanks...

 

[Ruddles]

It may be possible to write a routine in VBA to import the file treating the header lines appropriately, or even preprocess the text file to flatten the headers and/or remove unnecessary ones prior to import.

If you can post an example of what you're trying to achieve - the original text file and the resulting Excel worksheet - it would be easier to assess which approach might be best.

 

[theta]

One problem...I will be dealing with multiple sources (multiple clients) so need a flexible, dynamic solution.

Have found one other solution that fits the bill. The import wizard for Caseware IDEA, it allows for masks, multi line, multi header

But £3k price tag!