On Wed, Jul 22, 2009 at 11:34 AM, scabral<scabr...@lifespan.org> wrote: > > HI, > > i am new to SQLite and i currently have an access database that i would like > to convert over to a SQLite database. > > there are a couple of processes that would need to take place in order for > this to work and i'm not sure if SQLite has these capabilities: > > 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.
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. > 2. Neet to somehow create a front-end to query data from SQLite database > (not sure if SQLite has front end application). Lots of third-party applications. You might end up writing your own to suit your own requirements. > > 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). > > Thanks > scott -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= Sent from Madison, WI, United States _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
