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 ...