There is a table with a number of rows say 100 rows and just 3 columns, SerialNumber (Primarykey), and First Name and Resume. However, the column resume is empty. The resumes of all 100 persons are in a folder.

How:
1) Can I load the corresponding resumes to the resume column?
2) How to retrieve the data like Names and files like Resume from the database?

Guhar!

1. You can but you have to convert it to binary. So it's better to store in file system and store the pointers to DB if the content of file is static .
2.you can retrieve names and pointer from database and using the pointer, get the file from file system

Hi Sajha Keto,
store in file system and store the pointers to DB , how can they be automated if there are 1000 rows and 1000 corresponding documents? Appreciate if you elaborate it.

Create a folder somewhere and store all the resume files in there. Of course the file name should be unique. Now, just store the name of the files in the resume column. Now first read the entries from database and the files from the folder.

fuckeetow,

how to make sure right resume file goes to the right row?

The file name should be associated with the first name.

which tool or sample skript?

IT Mitrahru,

I found Ghiraunla's posting helpful for me too. Can anyone post the sample solution with Screenshots?

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.

Do you need to open the files to find out who's resume that is. If yes, it will little more complicated.

yes, that is what I need, open name, and other information along with the file, can be downloaded.