[sqlite] VBA Sqllite blob data

2015-05-15 Thread Preston King
e.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 SQLite

[sqlite] VBA Sqllite blob data

2015-05-14 Thread Preston King
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

[sqlite] VBA Sqllite blob data

2015-05-12 Thread Preston King
;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 > > nee

[sqlite] VBA Sqllite blob data

2015-05-11 Thread Preston King
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

[sqlite] VBA Sqllite blob data

2015-05-08 Thread Preston King
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] ODBC

2015-03-25 Thread Preston King
Thank you, I will take a look at it. 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

[sqlite] ODBC

2015-03-25 Thread Preston King
not been able to find anything newer. Has anyone written VBA code that can read records that longer than 255 characters? Thanks for your help. Preston King