Our agency maintains a Paradox 9 security database. Within this database is table (with 1311 records) which contains demographic data for all employees. One of the fields on this table is BLOB field which contains a photo of the employee. We are trying to migrate the data from this Paradox table to a new MS Access 2003 database. The data is able to be exported from Paradox; however, the new MS Access table is minus the BLOB field. Is there a practical way to move the contents of the Paradox BLOB field, en masse, to the new MS Access table? Thanks for any help.

It's fairly easy to write an ObjectPAL script to run through the file and save all the images to disk as <key field value>.BMP Then you would need something in Access to perform the reverse process. Eg. a simplified version of the routine I use for this purpose is here (this needs a folder called export in the work directory) :- method run(var eventInfo Event) var mytc tcursor s string f graphic fs filesystem endvar mytc.open("welderid.db") scan mytc : if mytc.photo.isblank() then message("No photo") else s="export\\"+mytc.name+".bmp" if isfile(s) then message(s+" already exists") else f=mytc.photo f.writetofile(s) message("Saved "+s) endif endif endscan mytc.close() endMethod