I am looking for advice on how to approach a project. I have an application that periodically writes a csv file with data in it to a folder on a desktop computer. It creates a new csv file each time.
I need the data from each of these csv files to be written to a SQL Server database which is located on a cloud server.
The table in the SQL server database has columns that match the data in the csv file exactly, so mapping the data fields is straightforward.
I would like a utility that "montors" the folder that these csv files are written to. When a new csv file is put in the folder I would like the utility to automatically write this data to the SQL Server database.
Do utilities like this exista and are commercially available? If not can anyone recomend an approach to writting a solution to do this. I work in Visual Basic.net. I have worked with ADO.net so have some experience with reading/writing data to SQL server.
I am looking for an easy to implement solution and would appreciate any advice more experienced programmers could offer.