Do you know of any third party applications that i could use to build the front end? This will need to run on local machines, not on servers. So, some sort of desktop application i would imagine....
thanks Scott P Kishor-3 wrote: > > 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 > > -- View this message in context: http://www.nabble.com/Ability-to-convert-Access-to-SQLite-tp24609886p24610625.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
