I have been able to use SQLite2009 Pro Management Studio to export the specific record from the DB3 file into Excel without any issues, the entire record appears correctly. I was trying to create VBA code within Excel to do the same thing. The blob record is a form of html code, it doesn't follow any typical code pattern so I had to write code to extract the data that I needed for the report(s). I have successfully created the routines and the report works well.
So the only part that I am having difficulty with is automating the importing of the record from the DB3 file into my worksheet. SQLite Studio exports the record that I need into an Excel worksheet just fine. I then copy the record into the worksheet that I created and execute my routines to produce the reports that have been requested. I am trying to have as little user interaction as possible. Thanks, Preston -----Original Message----- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Daniel Sj?din Sent: Monday, May 11, 2015 12:22 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] VBA Sqllite blob data 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-use > > > rs > > > > > _______________________________________________ > > 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
