Importing Data from a CSV file

Discussion created by mblair on May 7, 2014
Latest reply on May 8, 2014 by mblair

Hello all.


I am fairly new to Pi and still trying to learn the systems capabilities. So, please be patient with me.


Currently, I am using software to connect to a chromatagraph and retrieve the previous days data for its measurements. When the software runs, it exports the data to a .csv file on the computer that is running the software. What I want to do is have this data imported each night after the nightly data collection session.


It is my understanding that I should be able to import the .csv data to our SQL server. From there, I should be able to import the data in to our Pi server. However, all of my searches on information on how to do this has been exhaustive.


Does anyone have any good reference material (that is quick and to the point) that I can read that will help me get this project off of the ground?


Thank you for your help.