On Wed, 22 Jul 2009, scabral wrote: > i am new to SQLite and i currently have an access database that i would like > to convert over to a SQLite database. > > 1. Need to automatically import text file into SQLite database on local > machine (machine always on). I was thinking of using scheduled task to run > a script to do this, but not sure if that is possible. > 2. Neet to somehow create a front-end to query data from SQLite database > (not sure if SQLite has front end application). > > Basically, i want to get rid of the Access database because the user's have > to manually update the tables everyday from the text files that get ftp'd > over. I was trying to figure out a solution that would automatically load > the text files withouth any human intervention and then give the user's the > ability to view the data through some sort of front-end (similar to Access > form).
If your only problem is automating the import of these text files, there are simpler solutions than switching the SQLite. You should be able to create a scheduled script (VBScript, Python, whatever) that will import the text files directly into Access--the work involved will not be appreciably different than what will be required to script/program a utility to import the data into SQLite. By sticking with Access, once you have the script in place everything you currently have should work the same as it does now. Of course, there are possibly many other (good) reasons you want to migrate the whole thing to a SQLite backend, if so, proceed, but to solve just the problem you describe, you may want to stick to Access and just script the import. Chris _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
