How to unlock power of Office 2003 to archive, re-sort and publish

[Guest]

I have large amounts of old Word docs created (related to our company products) by numerous people with pretty standard sub headings inside.

How do I use the power of XML conversion or anything that Office 2003 can offer to store data from the docs into like "Excel" columns of information so that another user can use some interface to
1. See and choose from all the variable areas of work possible for each "column" of information (am thinking in Excel mindset) e.g. under "products" column, there are forecasting systems, sales systems, operations systems and under "cost" column there are low, medium, high and very high etc (something like auto filter capability).
2. Select combination of variables across "columns".
3. And later print out a report adhering to the particular selection containing more data that is written under the particular variables chosen e.g. a selection with Forecasting systems and high cost would have some writeup about the particular forecasting system in it automatically and the pre sales guys saves time and just have to vet the draft that was auto created from his selection .
4. And it should be accessible to only allowed personnel who do quotes for the company.

Regards,
KK

 

[Frank Kabel]

Hi
this sounds more like a medium scale project what you're trying to do
(and probably more like a database / reporting application). So
depending on the amount of data, structure of your queries you may have
a look into MS Access or something like Crystal Reports, etc.

 

[Mark E. Philpot]

The only thing I can think of is to save them as text
files and import into the excel sheet.

You do not need Access or Crystal Reports(whatever they
are!).

People just do not realise the versatility of Excel. It is
much easier to manipulate data and create forms, etc...

Also, I think Access is *!#*@!! (Too rude to put here)

regards
Mark

PS If you would to send a sheet to me, I will devise
something for you.

-----Original Message-----
I have large amounts of old Word docs created (related to

our company products) by numerous people with pretty
standard sub headings inside.

How do I use the power of XML conversion or anything that

Office 2003 can offer to store data from the docs into
like "Excel" columns of information so that another user
can use some interface to

1. See and choose from all the variable areas of work

possible for each "column" of information (am thinking in
Excel mindset) e.g. under "products" column, there are
forecasting systems, sales systems, operations systems and
under "cost" column there are low, medium, high and very
high etc (something like auto filter capability).

2. Select combination of variables across "columns".
3. And later print out a report adhering to the

particular selection containing more data that is written
under the particular variables chosen e.g. a selection
with Forecasting systems and high cost would have some
writeup about the particular forecasting system in it
automatically and the pre sales guys saves time and just
have to vet the draft that was auto created from his
selection .