PeopleRes Data Manager

Description

The utility can import data from multiple sources like SQL Server, Excel, ODBC, OLEDB, CSV into an Excel-like environment from where it can be processed further. Direct manipulation can be done on the grids and data from multiple sources can be added as separate tabs or merged into a single tab using a common field. SQL Insert and Update statements can be generated based on the data in the grid or data can be exported to Excel (either as a single worksheet or as a workbook with multiple tabs) or as CSV. Finally, the structure of the workspace can be saved as a Data Management Project which will save the settings of all the sheets in the project including settings for generating SQL statements (mappings between column names and field names). When opening the project, all the sheets will be recreated and data will be refreshed from the data sources as set up for each sheet. This is an utility that we developed for internal use and we're making it available free of charge for use by the public. We will add more features later on as we need them.