I need to create a background app like a 'job' that runs everyday in a specific directory. This job have to pick up a bunch of PDF forms that have been filled (all those forms are purchase orders) and extract then insert those data into a purchase orders Microsoft SQL database.

I know that Excel as a pretty good import feature for this situation but I need it to be automatic and more like a "Service" which really runs in background. I've been looking for ideas on how to approach the problem and I did not find much so, if you guys have any ideas I would love to hear about them.

Edit : I think a good solution would be a powershell script which does it all, loop, import, insert.

Thank you in advance.

CodePudding user response：

You can use a C# Console Application for that. Write a console app that extracts data from Excel/PDF then writes it directly to MsSQL database. Then trigger it with Scheduled Tasks on windows.