Macola-Excel Import

Easily import data from an Excel spreadsheet directly into the Macola ERP software database.

Enable your users to import data from an Excel spreadsheet into Macola

The Macola-Excel Import Utility tool by Harvest Ventures is a tool to import master data such as sales orders, purchase orders, items, customers and vendors from an Excel spreadsheet directly into the Macola or Progression database. This utility is available for purchase in full or based on specific data import requirements.

Features

Flexible database options

Able to input the source database and the destination database

Automatically runs multiple routines

Users can run multiple import routines automatically, one after another

Input and Output can be any format

The dynamic mapping tool included with this utility enables the source and output files to be specified

Execute queries for Excel

Allows users to execute a query from a selected database to generate an Excel file that can then be import into Macola

RELATED BUSINESS AUTOMATION TOOLS (BATS):