Advantages and applications of Apparo Flow

 

Excel-Import_email

Excel import via e-mail


kapitelpfeil_li Excel-Import_02_klein kapitelpfeil_re security_klein

Security

 

Excel import with
copy & paste

Excel-Import_01

It’s a situation we’re all familiar with: you have an Excel file with 20,000 rows of data which urgently needs to be saved in a database.

As is often the case, various data quality errors occur: a few data records are erroneous and can only be corrected by the users themselves.

It goes without saying that the IT department has a wide range of effective tools at its disposal, but the users are not qualified to use them. If an IT technician imported the data, they would lack the specialist knowledge required to correct data errors.

The solution is called Apparo Flow:

Apparo Flow allows users to open any Excel file, whether Office 2000, 2007 or newer, highlight the Excel data to be copied and, using the copy and paste feature, import it into a database – of course, only if they have the necessary authorisation.
 

There’s no limit to the amount of data you can import.

Import Excel data via file or as shown in the following video using copy&paste.