I am in need of completely exporting a excel spreadheet to a sql database. I believe that it can be acheived by writing some kind of DTS package.
the website fetches data from sql database, but the original data comes in a csv format, at the moment I have to manually go into DTS utilty of SQL server and then export the data into sql DB.
There is no integrity in the database All I need is some kind of script which drops the table and then recreate the table from the excel worksheet ...its is a flat table of some 20 fileds.
if it can be acheived through web in vb.net that would be ideal or any other suggestins if anyone has please let me know.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).