Lost

[galin]

Hi guys,

I have a big project ahead of me and I feel lost.I need to transfer a
existing database to MS Access. One way is to import it, and the othe
to transfer the database to Excel and link tables to Access. Th
problem is that the database is huge and consist of Employee_Name
Employee_ID,Badge_N, Time_Punch_In and so on.

The trnasfer of the database won't be a big of a deal, what bothers m
is how run reports. I need to run reports for each individual employe
based on a selected date(for instance From 12/12/1999 To 12/12/2001)an
the report should include Empl_Name,Badge,Name,if there is Overtime o
Vacation during this period..etc..

How can I approach this project? I mean this is a huge database, whic
after the transition will remain static and won't be updated. But ho
do I run all those reports based on a time frame.

Guys, Thank you
I appreciate any thought
Gali

 

[dandgard]

If this is a large db then forget the excel scenario. One way to insur
that you have timely reports is to import a portion of the db to acces
(You need to mirror the table structure from the old db) and develo
the reports and queries you will need while still maintaining your ol
db. Once you have the tools developed in Access, you then transfer al
data from the old db and start using the Access db. (How large is hug
- perhaps SQL Server is more appropriate.)

Also I have not heard you say how you are getting new data into the d
- or did you mean that there is no new data when you said static. I
there are time charges then how are you getting the new info. Are yo
doing this by yourself or do you have support???

Does the old db have ODBC connectivity??? How are you going to transfe
the data?

 

[galin]

Thanks for the answer Dandgard,

There will be no new records of this db. It'll remain static and wil
be used as an Old Empployee History File. The file is 155 mb large
enough to slow my computer to a point where it just crashes.

The db file is on old Kronos db file. I have to transfer it to Acces
in case there is query about employee's details.

The old file consists of 23 columns.It includes Employee's name, badge
division, Time Punch In-Out, Pay Codes..etc

So you suggest me to abandon Excel and try to import everything i
Access. I have to be able to run a report by Empl_ID and this repor
has to pul up the above stated info plus total regular hours, tota
vacation hours...I'm not sure how to run these totals, because th
hours with the pay code ,such as
8.00VAC
7.45REG
are included in the same column and I can't figure a way t
differentiate one from another.

It's not easy and I don't have much experience with Access so I am kin
of contemplating what the right way of doing this project is.

I'd appreciate any inpu

 

[John Vinson]

Hi guys,

I have a big project ahead of me and I feel lost.I need to transfer an
existing database to MS Access. One way is to import it, and the other
to transfer the database to Excel and link tables to Access. The
problem is that the database is huge and consist of Employee_Name,
Employee_ID,Badge_N, Time_Punch_In and so on.

FSVO "huge"... note that 155 MByte is well under 10% of the 2 GByte
capacity of an Access database (but is pushing very very hard at the
limits of Excel).

The trnasfer of the database won't be a big of a deal, what bothers me
is how run reports. I need to run reports for each individual employee
based on a selected date(for instance From 12/12/1999 To 12/12/2001)and
the report should include Empl_Name,Badge,Name,if there is Overtime or
Vacation during this period..etc..

This is just what Access is good at. You can use a criterion on the
date field of

BETWEEN #12/12/99# AND #12/12/01#

and get just those records; you can select any field in the table to
display in this query; you can base a printed Report or an onscreen
user-friendly Form on the query; you can even have the query look at a
Form or prompt for the dates rather than entering them literally.

How can I approach this project? I mean this is a huge database, which
after the transition will remain static and won't be updated. But how
do I run all those reports based on a time frame.

Just import the data into an Access table. You may want to "normalize"
- it sounds like it's one big flat table, and you might have good
reason to split it into an Employee table, an Hours table, and perhaps
some more tables. Post back if you need help doing so!