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-boun...@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