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 >
