Import excel to access database (1 Viewer)

saffar

New member
Local time
Yesterday, 22:59
Joined
Nov 1, 2005
Messages
6
I have a small database for marks i want to import excel file to access file based on student email
the mark column is (Total points)

e1 or any name i select) to exam1
e2 or any name i select) to exam2
e3 or any name i select) to exam3
e4 or any name i select) to exam4
e5 or any name i select) to exam5

anyone can help in accomplishing this
 

Attachments

  • importmarks.zip
    157.3 KB · Views: 221

saffar

New member
Local time
Yesterday, 22:59
Joined
Nov 1, 2005
Messages
6
Oh sorry for that
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 01:59
Joined
Feb 19, 2002
Messages
42,981
Just because you post in multiple forums doesn't mean we won't help you, we'd just like to be informed so we don't waste our time.

Rather than load each exam into a specific column, you need to change your table design so that each exam result is stored as a separate row. This design change will make all exam processing easier and it will keep you from having to make design changes to tables, queries, forms, reports, code if you want to add an additional exam.
 

Users who are viewing this thread

Top Bottom