[sqlite] VBA Sqllite blob data

2015-05-15 Thread Daniel Sjödin
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

[sqlite] VBA Sqllite blob data

2015-05-12 Thread Daniel Sjödin
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

[sqlite] VBA Sqllite blob data

2015-05-11 Thread Daniel Sjödin
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

[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

2015-05-04 Thread Daniel Sjödin
Hi, There is also a VBA wrapper that I've tested. Maybe the usage is a bit narrow but it shows how broad sqlite is. https://sqliteforexcel.codeplex.com/ Regards, Daniel Hello, Thanks for the additions to the awesome-sqlite [1] list. I added the ODBC and JDBC drivers to a new middleware