Importing remote http excel file as datasource?

Nov 30 2009 7:49 AM
Hi, Firstly I'm new. New to everything... including this forum, programming in C#, object orientated programming as a concept and indeed visual studio. Last week I built my first C# windows form program, basically reading information from a MySql database and organising it into several Listviews with certain controls. Now I'm trying something different which the last hour of Googling hasn't helped with. There is a remotely stored excel file (CSV) which I want to read from a Windows Form and eventually upload to a MySql database. I think I should be ok with the upload part, it's remotely connecting to this file and getting initial parsing of the data which is the issue. I've been succesful in configuring a local excel file on my machine as a datasource through the Visual Studio interface but have drawn a blank when trying to do it remotely. Any one any tips or ideas? P.S. I will come back with silly questions later, go easy.

Answers (3)