Movian
07-31-2011, 09:34 AM
Hey,
Have been looking around for a while and i am having trouble finding a simple method for a system to extract images from an MSSQL database (Stored as blobs in a field of type image). Then i need to save them to disk based on an associated ID number.
I don't even need a sub to do it.... a full blown program would be fine. But i need to extract 50GB of images and store them as individual files instead.
However if i can get a sub i can write a small DB to achieve what i need.
I did find this... however some initial tests resulted in some issues ( i think due to the way that i connect to the SQL database (I use the built in .adp connection then use currentproject.connection and SQL queries to create recordsets).
Any help on this would be appreciated. I am running out of time!
~Edit~
Also just been told they are not all images.... some are .doc files and some are .pdf..... if i write the binary stream to disk and name the file with the file name also stored in the table will that work ?
Have been looking around for a while and i am having trouble finding a simple method for a system to extract images from an MSSQL database (Stored as blobs in a field of type image). Then i need to save them to disk based on an associated ID number.
I don't even need a sub to do it.... a full blown program would be fine. But i need to extract 50GB of images and store them as individual files instead.
However if i can get a sub i can write a small DB to achieve what i need.
I did find this... however some initial tests resulted in some issues ( i think due to the way that i connect to the SQL database (I use the built in .adp connection then use currentproject.connection and SQL queries to create recordsets).
Any help on this would be appreciated. I am running out of time!
~Edit~
Also just been told they are not all images.... some are .doc files and some are .pdf..... if i write the binary stream to disk and name the file with the file name also stored in the table will that work ?