If you have interest in batch data input/import with validation, then be sure to spend some time investigating 'Excel to database', a new software solution from Lean Software, experts in lean process solutions.
If you wish to transfer information from Excel or CSV files to a data process or table, with the addition of client and server data validation, this solution is likely to be the most cost effective immediate solution and the simplest to configure -especially compared to batch file imports that are prone to failure because of invalid data.
Excel-to database will validate and upload data to a selected table or stored procedure server process.
Tasks can be defined for repeated use and tasks can shared in a workgroup environment.
The key concept here to understand is the fact that the process is lean - lets say you wish to import 2000 rows of important data, but 100 of those rows contain missing or invalid data. The data is important to your mission so you do not want to wait for someone to fix the invalid rows - you want the valid rows imported immediately. This new software allows the valid data to flow - and not to be caught up with data that is invalid within the same batch.
Please visit http://leansoftware.net for more details...