Jim Lawrence (AccessD)
accessd at shaw.ca
Thu Jun 17 11:41:40 CDT 2004
Hi Drew: This piece of code is an older technique for handling blobs. It now has been superceded by various streaming functions. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of DWUTKA at marlow.com Sent: Thursday, June 17, 2004 8:39 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Getting pictures into a blob in SQL Server MSKB Article #103257 covers how to do this in Access. I'm pretty sure this same code will work with SQL, since it is just using a recordset as an argument: http://support.microsoft.com:80/support/kb/articles/Q103/2/57.asp&NoWebConte nt=1 Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of jwcolby Sent: Thursday, June 17, 2004 7:56 AM To: SQLServer; 'Access Developers discussion and problem solving' Subject: [AccessD] Getting pictures into a blob in SQL Server I got a call from someone yesterday needing to get 25000 pictures into a blob field in SQL Server. The program he is attempting to use apparently stores the pictures it uses in such a field. These pictures are currently stored as GIFs (I believe) on the hard drive. I can write a program to cycle through a dir on the disk, but would I just read the text into a string and dump it into the field, save and move on? Has anyone ever done this? I included AccessD in this request as I am guessing I'll just do it through VBA in AccessD. John W. Colby www.ColbyConsulting.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com