{"id":204,"date":"2016-10-01T18:27:11","date_gmt":"2016-10-01T18:27:11","guid":{"rendered":"http:\/\/gearmage.com\/blog\/?p=204"},"modified":"2026-02-05T22:52:05","modified_gmt":"2026-02-05T22:52:05","slug":"save-csv-excels-to-a-database","status":"publish","type":"post","link":"https:\/\/gearmage.com\/blog\/save-csv-excels-to-a-database\/","title":{"rendered":"Save csv, excels to a database"},"content":{"rendered":"

If you have a need to save csv or excels\u00a0to a database, you can automate it with ease with Mail Attachment Downloader PRO Server. <\/a><\/p>\n

If you already receive these csvs or excels on\u00a0email, then great we will show you how to save these to a database.<\/p>\n

If not, you can email these csvs to an email address of your choice and have the program extract the attachment and automatically save it giving great power to you on-the-go.<\/p>\n

Save csv, excels to a database<\/h2>\n

First\u00a0ensure that you have a database connection configured as instructed here<\/a>.<\/p>\n

The next\u00a0step is \u00a0to create a Global rule filter so we can first identify the email that contains the csv, excel.\u00a0You can do so by adding a rule filter as shown earlier in this blog post<\/a>. You can also specify a\u00a0file type filter to choose .csv or .xls or .xlsx emails with filtering rules.<\/p>\n

Once those are both\u00a0done, saving the csv or excels to a database requires you to add an action.<\/p>\n

    \n
  1. Click Add action<\/strong> -> choose\u00a0Extract csv and save to DB\u00a0<\/strong>and then click the\u00a0Load sample file<\/strong> button to load a sample Excel or Csv file.\"csv<\/li>\n
  2. Pick the sheet\u00a0from the Choose sheet<\/strong> dropdown you want to load data from.\"csv<\/a><\/li>\n
  3. Click the Load column names from sample file <\/strong>button. This will load the column names as cell id’s\u00a0(eg. A1, B1 etc.).\"csv<\/a><\/li>\n
  4. If your Excel\/Csv starts from a header row (with header titles for each column), check the Starts from a header row<\/strong> and then click the Load column names from sample file<\/strong> again. This will auto-import the column names for easier manageability.\"csv<\/a><\/li>\n
  5. For each column you want to import, specify a field name within {} as shown below. By default all fields are imported as VARCHAR’s. If you want to change the type, you\u00a0can also choose Extraction Wizard for this field to change the field type or manipulate data from the Csv if needed.\"Csv<\/a><\/li>\n
  6. Once all fields have been given a name within {}, click the\u00a0Insert into database <\/strong>tab. Pick the DB source you have already configured<\/a> and the table name you want the data inserted into.\"csv<\/a><\/li>\n
  7. Now specify the SQL including fields that you want inserted as shown.INSERT INTO {TABLE_NAME} (‘Sales description’, ‘Sales price’, ‘Sales quantity’) VALUES ({DESCRIPTION}, {PRICE}, {QUANTITY})<\/strong>\"csv<\/a><\/li>\n
  8. Now click the Test SQL using Sample File<\/strong> button. If everything is correct, then you should see something like the below. You can then look at the database to ensure that the rows from the Excel or CSV were inserted into the DB.\u00a0\"csv<\/a><\/li>\n<\/ol>\n

    That’s it.<\/p>\n

    Now any emails matching the criteria would end up being added into the DB.<\/p>\n

    Further reading<\/h3>\n

    Some interesting how-to links and posts for further exploration:<\/p>\n