There are 2 utilities needed:
1) This utility will facilitate the import of a file into a SQL table. The interface will require the user to select a file (MS Excel csv most likely), request a password (use this to unprotect the file and re-protect afterwards), then import the data into a SQL table. There will need to be a control record created (in a SQL table) to record the who, what, when and how many records/rows etc. Once the data is imported, the file will need to be protected again, with the same password.
2) This utility is very similar to the first except it is exporting data from SQL. In this case, the password will be used to protect the file. The folder/filename will be prompted for. A control record will be created to record the who, what, when, where and how many.
Code can be done in C# or VB.Net. MS SQL Server 2008 database.
Milestones:
50% upon delivery of code and installation
50% when testing completed and signed off
Hi, I can create a generic application for this so you can use it with arbitrary table in the database and perhaps with additional feature to save export/import profiles to ease the job.
Thanks,
Luthfi
Hello. I am willing to complete your project with pleasure. please give me an opportunity to show you my skill.
i am very fluent with .net and databases