- Created temp database
- Import multiple csv files in temp database - separate table for each csv file.
*ability to set file type
*ability to set delimiter
*Row delimiter
*text qualifier
*First row has column names(yes/no) - If no ability needed to define column name(s) from configuration file
(example application config file will have: c:\[login to view URL]|heading1|heading2|heading3|heading4|…)
- Ability to select one or multiple destination databases. (sqlbulkcopy should be used for import)
- Preview files in dataGridView before importing
- Ability to run free form sql scripts on newly imported tables. Table naming convention should be consistent.
- All activities should be recorded in log file.
This is extremly small project. I am looking for a new freelancer you can do this for free and I will review him/her based on quality provided.