Jim Lawrence
jlawrenc1 at shaw.ca
Thu Sep 4 02:32:34 CDT 2008
Hi Stuart and Ken: The 'chunk' method is actually an older algorithm of copying images to and from a SQL DB. The new a much faster method is to use ADO streaming: http://www.freevbcode.com/ShowCode.Asp?ID=1802 HTH Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Tuesday, September 02, 2008 8:22 PM To: Discussion concerning MS SQL Server Subject: Re: [dba-SQLServer] Inserting Images into SS2K Here's an old reference to using BLOBs in Access: http://support.microsoft.com/default.aspx?scid=kb;en-us;103257 The VBA functions to read/write disk files to/from OLE Object fields given should work just the same with an ODBC connection to SQLServer with an image (long binary) data field. -- Stuart On 2 Sep 2008 at 20:01, KensProgramming wrote: > > > I have a client who has a table that contains the paths to images for > records. However, this client has now decided that they want to have these > images stored internally in SQL Server. I have a table then that is set up > to store these images, but I don't know how to go from the table with the > paths listed to the table with these images stored internally. I have > googled and looked through BOL, but haven't been able to find anything that > appears to help me. I could just be slow and blind. I could really use > anyone's help and actually need something to help me get started asap. > > Thanks > > Ken > Business Analyst > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > -- Stuart Mclachlan _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com