how to create web service to insert data into database

Do a normal insert (using webservice)  to your dbf file or whatever?

Later, use SSIS, to insert the records into your DBF database to SQL server. You can do schedule it. 

http://www.c-sharpcorner.com/uploadfile/muralidharan.d/basic-ssis-data-transformation/default.aspx


Please let me know, if it is not clear to you.