Résumé
This presentation focuses on the development of R utility scripts to help for the integration of Excel data files into relational databases. A first script provides user-friendly utility function to interact with a PostgreSQL database and process data: connecting to a database, extracting table fields, formatting datasets according to a specific table, etc.The second script provides utility function to check data from an Excel file following different controls: validation of data type (numeric, data, list of values ..), data format, unique values, missing values, etc.