Posted by: sajhamitra September 17, 2016
Login in to Rate this Post:
0 
? 
?
Here are the scenarios and solutions
1.) resume file name is same as first name in DB
Get the list of doc or docx files using the system command Insert into #temp xp_cmdshell e.g xp_cmdshell 'dir /b *.docx'. Your temp table will have list of file name. Hit the update statement by joining #temp table and your main table. This solution will only points to files in the directory. It does not load the file itself into the table
2.) resume file name is not same as name of the person in DB
In this case you have only one option and bit tricky. Your code have to open the content using office API and do a fuzzy lookup to get the name which is in first name column.
1.) resume file name is same as first name in DB
Get the list of doc or docx files using the system command Insert into #temp xp_cmdshell e.g xp_cmdshell 'dir /b *.docx'. Your temp table will have list of file name. Hit the update statement by joining #temp table and your main table. This solution will only points to files in the directory. It does not load the file itself into the table
2.) resume file name is not same as name of the person in DB
In this case you have only one option and bit tricky. Your code have to open the content using office API and do a fuzzy lookup to get the name which is in first name column.