How can I export a SQL Server BLOB field to a standard Windows JPG file?
Posted on 2009-03-30
I'm trying to determine the feasiblitly of processing a SQL Server table through MS Access, and for each SQL Server record, converting a BLOB field in the record to an individual JPG file in Windows. For example, if 10 SQL Server records were processed, then 10 JPG files would be produced in a Windows directory.
I'm assuming the use of MS Access, because Access can access SQL Server (thru ODBC) for input, and a Windows directory for output, simultaneously.
So, first of all, is this possible using MS Access? If so, what Access facility do I need to use?