I have an Access database. It used to have a field name picturepath which actually store the path of the image. for example, the record would have 3 fields. Id, SSN and PicturePath and PicturePath would look like C:\Irb\image\P355923999.jpg. P355923999 is the guy's SSN. Right now I have more than 10 thousands records. It is hard to manage all these image files. So I decide to create another OLE field, which will be picture and I want to import all these image files to this field as binary file. Does someone know is there some utility which I can use? Or do I have to write a VB program to do it?

Thanks very very much.