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 Fast Edit:
Apparo Fast Edit allows users to open any Excel file, whether Office 2000, 2007 or 2010, 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.
IBM Cognos BI