A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

importing text files into access and generating queries and reports



 
 
Thread Tools Display Modes
  #1  
Old November 7th, 2009, 01:21 AM posted to microsoft.public.access.forms
g_1
external usenet poster
 
Posts: 13
Default importing text files into access and generating queries and reports

I have 50 word documents in Word 2007 format. The data in the word
files is in a table of two columns and 10 rows consisting of
paragraphs which is basically a report how a unit in our company has
done for a given year for various parameters. I have such documents
for the past three years so I have 150 such word documents.

I have to analyze how each unit has progressed from the past year and
be able to generate a graph and some queries for that.

I will clarify with an example. I have a MS-Word 2007 File1.docx. It
has data in a table having 2 columns and 10 rows

Column 1 of table(this is not present in the file)
Column 2 of table(this is not present in the file)

First row(this is not present in the file)

Staff Turnover, Reasons for it It is nearly 3% for
this year 2006. It occurred due to difference in pay
and how we can avoid it they were offered
here and other positions they found, less upscale
movement
and career growth. We will provide more training classes for
them to
retain them and so on.

Similarly, Second row

Third row

..
..
..
..
..
Tenth row

I have such 50 files for each unit for this year, previous year and
the year before that.

Is there a way in Access 2007 which allows you to import 3 text files
(converted from Word 2007 by doing save and choosing the option Save
as plain text) for three different years for one unit, convert their
data(which is in a paragraph format as indicated above) to some
graphical format(like pie chart) and provide the ability to run some
queries on them like which unit had maximum(or minimum) revenue, staff
turn over, operating costs?

In my above example, I would want to see, what is the average staff
turn over for the years 2006, 2007, 2008 by running a query?

I realize it might be difficult since there are few numbers and lot of
data is in sentence format.

I also would want to see some graph format showing the turn over rate
by year.

Is there a method for doing this for all multiple units(50 in my case)
at once? That way, I can query staff turn over rate for 2006 which
would list the turn over rate for all units for that year?

Do I need to convert the data into some format first which Access can
use to create a temporary table which can be used to create the graphs
and run queries on?

Can someone please clarify if this can be done? Are there other
options using which might be easier to achieve what I am trying to do?

Thanks a lot.
  #2  
Old November 7th, 2009, 02:35 AM posted to microsoft.public.access.forms
g_1
external usenet poster
 
Posts: 13
Default importing text files into access and generating queries andreports

Seems the formatting did not come properly the first time.

I will clarify with an example. I have a MS-Word 2007 File1.docx. It
has data in a table having 2 columns and 10 rows

First row of table(the text "First row of table" is not present in
the file)

Column 1 of table(the text "Column 1 of table" is not present in the
file)
Staff Turnover, Reasons for it

Column 2 of table(this text "Column 2 of table " is not present in
the file)

It is nearly 3% for
this year 2006. It occurred due to difference in pay
and how we can avoid it they were offered
here and other positions they found, less upscale
movement
and career growth. We will provide more training classes for
them to retain them and so on.
Similarly, Second row

Third row

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.