CSV to Database

[gvanto]

Hey guys, I have a CSV file whose contents I would like to upload to an online MySQL datbases (running on a php server) using a simple C# app. I am not sure how to do this but I figured uploading the entire CSV file to the server if the first step. Is there a way of achieving this using ftp within C# somehow? Help much appreciated! Gerry C# newbie

Meet New People - Its Free! http://www.twoggle.com

[Christian Graus]

Can you connect with the MySQL database directly, or do you need to FTP the file and then have code on the server to parse and insert the files ? http://www.codeproject.com/cs/internet/ftplib.asp[^] might help.

Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

[gvanto]

Hi Christian, Thanks for this ftp article, I'm sure it'll do the trick (yes file has to be uploaded, then Mysql inserted by running php script on server). Many thanks! Gerry

Meet New People - Its Free! http://www.twoggle.com