Isn't that the actual size limit of Excel strings?
At 15:27 11/05/2015, you 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
`---
