Member Avatar for Fangling

i have an excel file which contains the following:
(only part of the file)

1 SEG-AMK EG1832 Mechanics and Materials 286 1.5 EG1832
2 SEG-AMK EG1833 Electrical Principles 375 1.5 EG1833 EG1952 EG1903
3 SEG-AMK EG1835.1 Engineering Mathematics (1) 456 1.5 EG1835 EG1001
4 SEG-AMK EG1835.2 Engineering Mathematics (2) 363 1.5 EG1907 EG1681 EG1951 EGB101 EGC101 EGD101 EGF101 EGH101
5 SEG-AMK EG1004 Analog Electronics 262 1.5 EG1004
6 SEG-AMK EG1009 Electric Circuits 229 1.5 EG1009
7 SEG-AMK EG1010 Digital Electronics 229 1.5 EG1010
8 SEG-AMK EG2008 Engineering Mathematics 2B 563 1.5 EG2008 EG2681 EGB207 EGC207 EGD207 EGF207 EGH207 EGJ207
9 SEG-AMK EG1008 Engineering Mathematics (1A/1C) 570 1.5 EG1008 EGB107 EGC107 EGD107 EGF107 EGH107 EGJ107
10 SEG-AMK EG2010 Electronic Communication 221 1.5 EG2010

and a datagrid as well as access database containing the following:

ModuleCodes AdminNo
EG1001  112960A 
        114424H 
        120428G 
        120595K 
        123452P 
        124090Q 
        125559F 
        125662E 
        126117Y 
        126184K 
        126386A 
        126387F 
        126388W 
        126389J 
        126390Q 
        126391K 
        126394N 
        126395C 
        126396P 
        126397R 
        126398E 
        126414K 
        126417N 
        126418C 
        126419P 
        126423T 
        126424H 
        126428Z 
        126429B 
        126430U 
        126431G 
        126455A 
        126495S 
        126501A 
        126503W 
        126511P 
        126514L 
        130016W 
        130019K 
        130020D 
        130022N 
        130034B 
        130036G 
        130351H 
        130355Z 
        130361W 
        130362J 
        130368C 
        130485R 
        130488T 
        130516Z 
        130737P 
        130787T 
        130799J 
        130845J 
        130856T 
        131062L 
        131067M 
        131076Q 
        131453L 
        131485G 
        131504M 
        131834J 
        131838Y 
        131841P 
        131893X 
        131903J 
        132212L 
        132873Y 
        132891W 
        133430E 
        133609Y 
        133882Q 
        134125S 
        134127Z 
        134134J 
        134390D 
        134745X 
        134775A 
        134781D 
        134787E 
        134795B 
        134870J 
        134923P 
        134929X 
        134930S 
        134972L 
        134973T 
        134974H 
        134989Y 
        135009Q 
        135068S 
        135078Q 
        135105N 
        135107P 
        135183S 
        135594T 
        135598M 
        135619X 
        135622Z 
        135678D 
        135693U 
        135715B 
        135734X 
        135744J 
        135754L 
        135777L 
        135786G 
        135789W 
        135810A 
        135815K 
        135835W 
        135836J 
        135843P 
        135916T 
        135995F 
        136020J 
        136027P 
        136035M 
        136050P 
        136056X 
        136075E 
        136084U 
        136086A 
        136093Y 
        136107U 
        136118C 
        136142P 
        136175B 
        136276D 
        136320Q 
        136325C 
        136601C 
        136683G 
        136692N 
        136706G 
        136744T 
        136745H 
        136883H 
        136884X 
        136917J 
        136919K 
        136922N 
        136925R 
        136926E 
        136929H 
        136930X 
        136939W 
        136944Y 
        136945N 
        136948R 
        136949E 
        136989D 
        136991N 
        136992C 
        136993P 
        136994R 
        136995E 
        137000S 
        137006A 
        137009J 
        137010Q 
        137018E 
        137019L 
        137020T 
        137023S 
        137054W 
        137201R 
        137204T 
        137206X 
EG1002  113426D 
        121208B 
        122329T 
        126136J 
        130016W 
        130019K 
        130020D 
        130022N 
        130034B

only part of the data.

this piece of data means, for this module (subject, EG1001), these students(112960A,114424H, ... ) are taking it

i want to compare this 2 datasets to get the modulecode conflictive list.

Example:
paper 1 : EG1832
Paper 2 : EG1833,EG1952,EG1903
Common Students: 5
Paper 10:Paper20 = 30 students (AdminNo)

Im actually doing a data loader for exam scheduling data.

Anyone give me a head start on how should i go about doing this in the easiest method, simplest to understand? Let me know of any possible ways i could do this.

i dont mind to have to transfer the data from excel to access database first, but preferrably by coding.

Thanks in advance!

  • 2 Contributors
  • 2 Replies
  • 205 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by Fangling
Member Avatar for Begginnerdev

If you are storing large amounts of data, which it looks like you are, I suggest a database backend.

A table for students, classes and a junction table:

tblClasses
ID | Class | Comments
Auto | VarChar | VarChar

tblStudents
ID | Name | StudentNumber
Auto | VarChar | VarChar

tblLink
ID | tblStudent_ID | tblClassesID
Auto| Integer (FK) | Integer (FK)

Classes will look like:

0,SEG-AMK EG1832 Mechanics and Materials 286 1.5,EG1832
1,SEG-AMK EG1833 Electrical Principles 375 1.5,EG1833 EG1952 EG1903

Students will look like:

0,John Doe, 130019K
1,Woody Woodpecker,130020D

Your Junction Table will look like

0,1,0 - Woody is taking Mechanics and Materals 286
0,1,1 - Woody is taking Electrical Principles 375
0,0,0 - John is taking Mechanics and Materials 286

Edited by Begginnerdev
Member Avatar for Fangling

thanks for that. but i think its too much for me. is there any other easier way?

paper 1 : EG1832
Paper 2 : EG1833,EG1952,EG1903
Common Students: 5, then:
giving output:
ConflictPaper    No.Students   AdminNo
Paper 10:Paper20  30           111411H 163722U

displaying in multi line textbox or DGV

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.