We have created an app that pulls order information from Order Entry and populates a spreadsheet.  We have optional fields that have been added to order entry that indicates one of our Buyers.  The Manager opens the spreadsheet and assigns a buyer to each order.  The spreadsheet is then saved and a script is run that saves the excel file from one server to our database server and writes the changes to the correct SQL table.  Below is information from one of my techies that I thought might help explain it better than what I could:

Currently, the Sage Custom apps opens an Excel spreadsheet located on the app server

There are connection strings configured in the Excel files to pull data from the Sage company DB in SQL

Users change the Excel file and save it

The changes saved to this file are not written to the SQL DB

What is required to get the date from Excel into the database is what needs to be better automated*.

The Excel file is copied from the app server to the db server

A sqlcmd is called to import data from Excel (on the db server) into sql

*Note: We have a “watcher configured to look for changes to this file and perform the remaining steps but it’s not working consistently:

What would be better is if changes to the Excel file that the user opens are written to SQL on save. No file copy or sqlcmd required. This should all be seamless and invisible to the end user. They should just have to open the file, make a change and save the file.

Does anyone know of any 3rd party add-ons that do this or might help?

Does anyone else do this sort of thing that works?

Thanks for any suggestions offered in advance.

David