Paradox 9 BLOB Field MS Access 2003

Dell UNKNOWN
October 16, 2009 at 07:30:16
Specs: Windows XP Home, unknown
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.


See More: Paradox 9 BLOB Field MS Access 2003

Report •


#1
October 24, 2009 at 14:06:02
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



Report •
Related Solutions


Ask Question