What is in the blob? What are you trying to see when you dump it to the sheet?
RBS On Mon, May 11, 2015 at 2:27 PM, Preston King <PKing at dot.state.nh.us> wrote: > I have a db3 config file that contains several different records. I need > to select one specific record and store it in an excel worksheet cell. I > have been able to create a routine to extract the information that I need > once I get the record into a worksheet cell. The problem that I have run > into is the record is longer than 255 characters and gets truncated at that > limit. > > > -----Original Message----- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto: > sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Bart Smissaert > Sent: Friday, May 08, 2015 5:23 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] VBA Sqllite blob data > > What do you mean with: into Excel? Into a cell in the worksheet, into a > VBA variable? > What code did you try? I never use blobs, but I don't think it should be a > problem. > > RBS > > > > On Fri, May 8, 2015 at 8:15 PM, Preston King <PKing at dot.state.nh.us> > wrote: > > > Does anyone have an example of how to read sqlite blob records, that > > are not pictures, into Excel? I have been trying to find some VBA code > > to do this but am not having much luck. Thanks > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
