I would recommend Talend (http://www.talend.com/). It allows for export/import to/from almost any structured data source (including sqlite and Access) and has very good scripting capabilities (a visual designer which generates java or perl code). It doesn't have a scheduler but this may be managed thru some other tool such as http://jobscheduler.sourceforge.net/ or, as you said, the windows task scheduler.
> -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of scabral > Sent: miércoles, 22 de julio de 2009 02:30 p.m. > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Ability to convert Access to SQLite > > > The OS is Windows XP. I know some VB script, some pearl and i'v used > Visual > VB and C# as well. > > I was thinking that the script would called from a windows scheduled > task > and the script would then import the text file into the table in > SQLite...Sounds easy, but i'm not sure what's available to create > script. > > thanks > Scott > > Simon Slavin-2 wrote: > > > > > > On 22 Jul 2009, at 5:34pm, scabral wrote: > > > >> 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. > > > > What programming languages or scripting languages do you know ? > Which > > operating system is that machine using ? > > > >> 2. Neet to somehow create a front-end to query data from SQLite > >> database > >> (not sure if SQLite has front end application). > > > > It can talk to many many programming languages. This will be > > relatively easy, it's getting the data out of Access, and from the > > text files that's hard. > > > > Do your users have access to web browsers ? Can you write in PHP ? > > Do you have a web server set up ? > > > > Simon. > > _______________________________________________ > > 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-tp24609886p24610956.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 > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 8.5.392 / Virus Database: 270.13.23/2254 - Release Date: > 07/22/09 05:59:00 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
