Csv or Excel to a database

Ever have a need to get reports / data from a CSV or Excel file into a database table? If you receive many csv or excels typically via email (usually reports, invoices etc., you may need more automation/development to save that data into a database.

Mail Attachment Downloader PRO Server lets you take any emails containing the CSVs or Excels that you may receive on a schedule and insert that data into a table in a SQL database of your choice. The Server can run 24x7 unattended as a Windows Service either on a local Windows Server or in the cloud using Windows Azure.

We have detailed instructions here on how to setup the PRO Server to do just this: http://gearmage.com/blog/2016/10/01/save-csv-excels-to-a-database/

If you have any questions on this setup, please contact support@gearmage.com.

Feedback and Knowledge Base