ETL and Data Integration tools - Modern ETL software for everyone

Hello

Here is my requirements.

1. Visually map Excel cell values to SQL Server database table columns.

2. During mapping, the Excel cell values need to be manipulated (for instance, splitting a single Excel cell value using Visual Importer’s inbuilt functions and mapping it to two different database columns).

3. Do you have any statistics on the time taken by the tool, say, to load 100 rows?

Based on our requirements, can you please suggest if we should go for Standard or professional edition?

Thanks,
Peter

If you want automation go for enterprise version

Regarding performance it takes seconds to load 100 records from excel

John