Well, Pighin, Ryan wrote: > Hi All - We have a new utility in our environment using SQLite and I was > wondering if there was a way to dump all the database into Access so we > can create reports on the databases?
Why not attach the SQLite database into Access and create your reports? That way changes in the database will be reflected in the reports without having to dump it again. Use an SQLite ODBC driver (for example, the one at www.ch-werner.de/sqliteodbc/ ) and use the linked tables command to attach the SQLite database tables in. Guy _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users