Excel csv extension

[Mike Cheung]

I was working in a school a year ago.
The IT team asked us to submit marksheet as csv files, say student names in column 1 and marks in colume 2.
Then I submit it online and then they in return will print us report cards after gathering all csv files from subject teachers.

Can someone tell me briefly what the mechanism can be? Is it an Excel macro? Where can I learn these? Can Excel macro be a tool as a database developer / user platform?

Thanks in advance.

 

[iPwn]

If they asked you to submit it via .CSV then they are most likely not using excel to process the file. CSV (Comma Separated Values) saves the file as a plain text file. Each Row is separated by carriage return, and each column by comma. For example, I made a quick csv and opened it with notepad and you see this:

ID,Name,Grade
1,Aaron,A
2,Brian,B
3,Clarence,C
4,Don,D

This makes it easy for them to write a simple program to take the data and process it for the grade report. As far as database entry goes, you would want to look at how your database is laid out, who would input data, etc. to determine how you want to bulk upload data. Microsoft Product to Microsoft Product and you can typically just copy and paste data around, but again, that largely depends on who and what you're going to be using the database for.

 

[strollin]

Excel can read .csv files directly and separate the values into rows and columns, no macros needed.