Hjælp til at lave et Execl ark om til en database - Døgnrapport

Have you tried importing one of the excel sheets into Access.


First of all you need to get the table design in place. Once thats in place you can start puuting forms/reports together.

Terry -> har forsøgt at impotere excel arket hvilket den ikke ville, kommer men en fejl.

Jeg er godt klar over at jeg skal have noget design mæssigt på plads først men det er sådan ca her jeg står af. hvad hvad har jeg brug for m.m.

I can see from your profile that you should have some knowledge of database design.

Beredskabsassistent/Brandmand, Horsens Kommune
2005 - 2007 SAP Portal Programmør, BPC.dk

Uddannelse
2001 - 2004 Datamatiker, Horsens Handelsskole
1998 - 2001 HHX, Horsens Handelsskole


Do you have any knowledge of Access?


You can send me your dB and I will see if I can import the Excel shhet but I dont have time to make the dB for you which, if you dont have any knowledge of Access can take some hours.

ekspertenATsanthell.dk
AT = @


I'm off out for and hour or so, will take a lokk later.

Terry -> sådan mail sendt.

Som skrevet i mailen også så har jeg en lille Access viden, men design af databaser har aldrig været min stærke side så det er det jeg står og mangler en som hurtigt og nemt lige kan sætte tabellerne og relationerne op så jeg selv kan bygge videre på den.

After looking at the dB:

Table contains information of your staff
tblPersonnel
ID (Autonumber) Primary Key
FirstName       
SurName
. (other fields you might need)
.

Contains texts for the position (rank) of what each staff member has while on duty. For example VAGTH. BRANDMESTER or VAGTH. MANSKAB ..
IE the texts you have in lines 2 to 8.
tblPosition
ID (Autonumber) Primary Key
Position
. (other fields you might need)
.


This table contains information concerning the "Vagt" Date etc.
tblVagt
ID (Autonumber) Primary Key
DateTimeFra (datetime type)
DateTimeTil  (datetime type)
. (other fields you might need)
.


Texts for the types of "opkald" you get such as NØDKALD / NØDLALDSNUMMER and BRAND & INDSATSER.
IE the texts you have in Excel which are rotated.
tblOpkaldType
ID (Autonumber) Primary Key
OpkaldText
. (other fields you might need)
.


Information on the received opkald. IE the data from row 11 and after.
tblOpkald
ID (Autonumber) Primary Key
DateTime        (datetime type)
OpkaldTypeID  (long integer)  Use the Lookup type to create. The field is related to ID in table tblOpkaldType.
Haendelsen
Fortaget
. (other fields you might need)
.


Table contains information of the staff for a specific "vagt"

tblVagtPersonell
VagtID              (long integer)  Use the Lookup type to create. The field is related to ID in table tblVagt.
PersonnelID    (long integer)  Use the Lookup type to create. The field is related to ID in table tblPersonnel.
PositionID        (long integer)  Use the Lookup type to create. The field is related to ID in table tblPosition.
. (other fields you might need)
.

Du kan få den her!~)

www.spgprogramming.com/access/blaablink.mdb

...et gratis fix!~)

SPG -> alletider det var jo lige det jeg søgt, det kan jeg uden de store problemer arbejde videre med.

Takker her fra.
Og god weekend