GIANTOCR
asked on
automatically upload csv data to sql server
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.
Thank you.
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.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for the help.
ASKER
I am looking for a solution that will run on a number of remote desktops and send the data to a SQL Server database located on a cloud server.