Import excel to access database

[saffar]

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

 

[Gasman]

Crossposted yesterday https://www.accessforums.net/showthread.php?t=83699

 

[saffar]

Oh sorry for that

 

[Pat Hartman]

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.

 

[saffar]

Thank you for clarifying