Hi, Have a look at the last post in this thread. Never tested this but if true then maybe it's an idea to try to implement it in vba part of sqliteforexcel.
http://stackoverflow.com/questions/2516702/getting-around-the-max-string-size-in-a-vba-function Regards, Daniel Den 11 maj 2015 18:17 skrev "Bart Smissaert" <bart.smissaert at gmail.com>: > 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 > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
