More : Subfiles to Excel is OK. But why not use ... Excel's Pivot Tables !

[Seamus at partage.org]

Adding a bit to my own posting of yesterday. In point 6.


6. Then there's a question about do you wan't to use MS Query to import the
data using ODBC. The answer is "yes". Then there's questions like Do you
want to create a data source? Answer NO. Which driver ? There should be a
dropdown list with "MS Text files". That's the one to click.

If you can't see that you have to quit and install the "MS Office Text
Importers and Converters and ODBC stuff" from the Control Panel, Add /
Remove Programmes, MS Office, Details or Options or ...

The important thing here is that you don't have to create a "dsn".

Added bit ----------------
An important detail when you're setting up the connexion to the external
data in point 6.
In earlier versions of Windows, there is an icon in the Control Panel which
lets you add ODBC connections.
In Windows 2000 this function has been buried further down.
You have to go to Control, Panel, Admin Tools, and then Data Sources (ODBC).
If MS text Driver is not in the list then click on Add, Find MS text Driver
(*.txt, *.csv) and add it.
You have to give a name to it when you add it, I called mine 'MS Text
Driver', (wildly original !) and that does the trick.
Now when you go back to MS query you will find "MS text driver" (or whatever
you called yours) in the list as a driver to establish the connexion.
Use it.
----------------------End of added bit


I will maybe get all this tidied up and added to my website in a HowTo...
It's the weekend, yet I have already received 3 replies/enquiries.