I have an application that copies the contents of an Excel file to a SQL Table. It works fine. I’ve tried to make a Service using Visual Studio but it doesn’t trigger the code that I have inserted in the Service. What is the proper way of triggering the codes inside a Service?
I’ve tried to use a Timer and set its interval to 10000 so the Service will copy the content of an Excel file to a SQL Table every 10 seconds but still it doesn’t work.