[sqlite] VBA Sqllite blob data
Hi Preston, That's good news. It would be really interesting to hear how you solved it. Din you hit any particular obstacles? BR Daniel Thank you for all of your suggestions and tips. I have been able to use the code samples and extract the data that I needed from my database in a test scenario. I am now modifying it to work with the live database. Thanks again. Preston King, NHCPM NH Department of Information Technology at NHDOT - TMC 110 Smokey Bear Blvd. Concord NH 03302 (603) 271-6862 www.nh.gov/doit Statement of Confidentiality: The contents of this message are confidential. Any unauthorized disclosure, reproduction, use or dissemination (either whole or in part) is prohibited. If you are not the intended recipient of this message, please notify the sender immediately and delete the message from your system. -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto: sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Kevin Benson Sent: Tuesday, May 12, 2015 10:15 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] VBA Sqllite blob data On Tue, May 12, 2015 at 7:41 AM, Preston King wrote: > 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-bounces at 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-stri > ng-size-in-a-vba-function > > Regards, > Daniel > Den 11 maj 2015 18:17 skrev "Bart Smissaert" : > > > 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 > > > > 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 > > > > > > 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 I, too, believe SQLite for Excel is your best bet (as others have suggested) so to add to the information supplied... I noticed mention of: *XLSQLite.xlam * http://www.gatekeeperforexcel.com/other-freebies.html "It uses SQLite for Excel to interact with SQLite datab
[sqlite] VBA Sqllite blob data
Hi Daniel, I received several suggestions but the one that eventually help me the most was this one, https://sqliteforexcel.codeplex.com/. I spent a fair amount of time reviewing the code contained in the worksheet. I then started modifying it to access a copy of my database. After some trial and error I was able to figure out which pieces of code I needed for my project. Thanks for all of the help. Preston Statement of Confidentiality: The contents of this message are confidential. Any unauthorized disclosure, reproduction, use or dissemination (either whole or in part) is prohibited. If you are not the intended recipient of this message, please notify the sender immediately and delete the message from your system. -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Daniel Sj?din Sent: Friday, May 15, 2015 8:01 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] VBA Sqllite blob data Hi Preston, That's good news. It would be really interesting to hear how you solved it. Din you hit any particular obstacles? BR Daniel Thank you for all of your suggestions and tips. I have been able to use the code samples and extract the data that I needed from my database in a test scenario. I am now modifying it to work with the live database. Thanks again. Statement of Confidentiality: The contents of this message are confidential. Any unauthorized disclosure, reproduction, use or dissemination (either whole or in part) is prohibited. If you are not the intended recipient of this message, please notify the sender immediately and delete the message from your system. -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto: sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Kevin Benson Sent: Tuesday, May 12, 2015 10:15 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] VBA Sqllite blob data On Tue, May 12, 2015 at 7:41 AM, Preston King wrote: > 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-bounces at 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-stri > ng-size-in-a-vba-function > > Regards, > Daniel > Den 11 maj 2015 18:17 skrev "Bart Smissaert" : > > > 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 > > > > 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? I
[sqlite] VBA Sqllite blob data
Thank you for all of your suggestions and tips. I have been able to use the code samples and extract the data that I needed from my database in a test scenario. I am now modifying it to work with the live database. Thanks again. Preston King, NHCPM NH Department of Information Technology at NHDOT - TMC 110 Smokey Bear Blvd. Concord NH 03302 (603) 271-6862 www.nh.gov/doit Statement of Confidentiality: The contents of this message are confidential. Any unauthorized disclosure, reproduction, use or dissemination (either whole or in part) is prohibited. If you are not the intended recipient of this message, please notify the sender immediately and delete the message from your system. -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Kevin Benson Sent: Tuesday, May 12, 2015 10:15 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] VBA Sqllite blob data On Tue, May 12, 2015 at 7:41 AM, Preston King wrote: > 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-bounces at 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-stri > ng-size-in-a-vba-function > > Regards, > Daniel > Den 11 maj 2015 18:17 skrev "Bart Smissaert" : > > > 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 > > > > 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 > > > > > > 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 I, too, believe SQLite for Excel is your best bet (as others have suggested) so to add to the information supplied... I noticed mention of: *XLSQLite.xlam * http://www.gatekeeperforexcel.com/other-freebies.html "It uses SQLite for Excel to interact with SQLite databases and provides a simple GUI that facilitates the creation and manipulation of SQLite databases directly from within Excel. It also provides functionality to execute SELECT statements directly from within an Excel array formula and return the result in a range of cells." -- -- -- --???-- K e V i N ___ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] VBA Sqllite blob data
Hi Preston, my last suggestion to try to expand the variable size on vba side of sqliteforexcel is really not worth it. Looks like it have been taken care of already (well, sort of). https://sqliteforexcel.codeplex.com/discussions/266048 If I understand this right you will get a byte array when using the SQLite3ColumnBlob function. Then you need to convert it into text. Have a look at the end of the thread. Suppose you will use StrConv function. Daniel 2015-05-12 13:41 GMT+02:00 Preston King : > 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-bounces at 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" : > > > 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 > > 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 > > > 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 > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Daniel Sj?din +46 706 65 22 86
[sqlite] VBA Sqllite blob data
On Tue, May 12, 2015 at 7:41 AM, Preston King wrote: > 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-bounces at 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" : > > > 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 > > 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 > > > 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 I, too, believe SQLite for Excel is your best bet (as others have suggested) so to add to the information supplied... I noticed mention of: *XLSQLite.xlam * http://www.gatekeeperforexcel.com/other-freebies.html "It uses SQLite for Excel to interact with SQLite databases and provides a simple GUI that facilitates the creation and manipulation of SQLite databases directly from within Excel. It also provides functionality to execute SELECT statements directly from within an Excel array formula and return the result in a range of cells." -- -- -- --???-- K e V i N
[sqlite] VBA Sqllite blob data
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" : > 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 > 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 > > 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
[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" : > 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 > 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 > > 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 >
[sqlite] VBA Sqllite blob data
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 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 > 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] VBA Sqllite blob data
Hi Simon, >On 11 May 2015, at 3:25pm, Jean-Christophe Deschamps > wrote: > > > Isn't that the actual size limit of Excel strings? > >Sort of. Although Excel cells can contain text longer than 255 >characters, VBA functions ignore text parameters after the 255th >character. This is because VBA, when originally written, used >Pascal-type strings internally. > >Simon. Yes, I meant "using either VBA or COM objects". People regularly complain that they hit this limit when using Excel with AutoIt (the communication uses COM). JcD
[sqlite] VBA Sqllite blob data
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 >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] VBA Sqllite blob data
On 11 May 2015, at 3:25pm, Jean-Christophe Deschamps wrote: > Isn't that the actual size limit of Excel strings? Sort of. Although Excel cells can contain text longer than 255 characters, VBA functions ignore text parameters after the 255th character. This is because VBA, when originally written, used Pascal-type strings internally. Simon.
[sqlite] VBA Sqllite blob data
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 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] VBA Sqllite blob data
You may find what you need here: https://sqliteforexcel.codeplex.com/ Good luck, -Bill On 5/8/2015 3:15 PM, Preston King 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 > > > - > No virus found in this message. > Checked by AVG - www.avg.com > Version: 2015.0.5941 / Virus Database: 4342/9728 - Release Date: 05/08/15 > >
[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 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] VBA Sqllite blob data
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