Go Back   Computer Forums > General Computing > Software and Operating Systems
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 08-08-2012, 11:24 AM   #1
Beta Member
 
Join Date: Aug 2012
Location: Hong Kong
Posts: 1
Thumbs down Excel csv extension

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.
__________________

Mike Cheung is offline   Reply With Quote
Old 08-09-2012, 01:16 PM   #2
..m.0,0.m..
Site Team
 
iPwn's Avatar
 
Join Date: May 2010
Location: USA
Posts: 3,870
Default Re: Excel csv extension

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:

Code:
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.
__________________

__________________
Me: You'd think as the dominant species we wouldn't be so effing stupid.
J: We're just intelligent enough to be completely effing stupid.
iPwn is offline   Reply With Quote
Old 08-09-2012, 07:51 PM   #3
Fully Optimized
 
strollin's Avatar
 
Join Date: Mar 2011
Location: USA
Posts: 1,943
Default Re: Excel csv extension

Excel can read .csv files directly and separate the values into rows and columns, no macros needed.
strollin is offline   Reply With Quote
Reply

Tags
csv, database, excel, macro, office

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 06:22 PM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0