Posted on: 8/13/2014 4:54:28 PM | Views : 410

Hi I need some help with my littler project here. I have a excel file with some data in it. User will receive this file everyday. 1) upload this excel into sql severe 2) sql server has a table structure related to this excel file 3) copy all excel data to this sql table 4) sql also have another table to run a join query with data uploaded by excel 5) display the result back to user on unmatched data. I can do sql query but not sure where to start on uploading excel file to sql server. Can anyone give some suggestion or a starting point Thanks

Go to the complete details ...