On Wed, 22 Jul 2009, scabral wrote: > 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.
Scott, Given your needs and wants, I'll second the suggestion that you first automate getting the scripts into Access, then work on the conversion to SQLite. BTW, the language is Perl, not Pearl. :-) It's easy to get confused since those who like it think it's a gem. I _strongly_ recommend that you get away from the Microsoft-specific languages, and use one that works on any platform. While I prefer Python because it has extensive support for science, mathematics, graphing, etc. you might want to consider Ruby so you can build a web-hosted application. Many open source tools have been ported to Microsoft over the years so you cannot go wrong by learning to use these. Learn to work comfortably in a terminal so you can write code and administrative tools in a text editor. You'll not only learn the language better than if you relied on GUI tools to draw things, but you'll know just what it's doing under the hood. As a developer you'll want that knowledge and control. 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
