On Wed, 22 Jul 2009, P Kishor wrote: > Sure it is possible. You will have to choose your favorite programming > language, write a program to locate and import the local text file, and > set up a scheduler to do so periodically.
> Lots of third-party applications. You might end up writing your own to > suit your own requirements. Allow me to expand on these thoughts. SQLite is a database engine that has a command line interface. However, it is most often used embedded in an application. In Scott's case, the application would consist of the user interface, the middleware, and reporting capabilities. Just about any programming language can be used. I prefer python but ruby is also quick, easy, and reliable. The UI would have whatever is wanted or needed by the users. The middleware controls the acquisition and import of the text files can be run as a cron job or by selecting a menu item. Any needed reports can be written in the tools available for that language. There are a suite of tools called 'mdb' that facilitate migration of data from Access to real RDBMSs. I've not used them so cannot comment on their effectiveness. Rich -- Richard B. Shepard, Ph.D. | Integrity Credibility Applied Ecosystem Services, Inc. | Innovation <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
