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, 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 Bart Smissaert Sent: Wednesday, March 25, 2015 8:12 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] ODBC Best is to use the VB (6 and VBA) wrapper from Olaf Schmidt you can download here: http://www.vbrichclient.com/#/en/About/ Examples how to use are there as well. RBS On Wed, Mar 25, 2015 at 12:06 PM, Preston King <PKing at dot.state.nh.us> wrote: > Hello, > > I recently installed the sqliteodbc, sqlite3 ODBC v0.9991.00.00, to > use with Excel 2010. I created some VBA code to import sqlite data > into my worksheet. The issue that I am having is that data is > truncated to 255 characters. I am assuming that I have the latest ODBC > driver as I have 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 > _______________________________________________ > 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