sqlite-users-requ...@sqlite.org wrote: > ------------------------------ > > Message: 5 > Date: Wed, 22 Jul 2009 09:34:48 -0700 (PDT) > From: scabral <scabr...@lifespan.org> > Subject: [sqlite] Ability to convert Access to SQLite > To: sqlite-users@sqlite.org > Message-ID: <24609886.p...@talk.nabble.com> > Content-Type: text/plain; charset=us-ascii > > 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). > > When importing data into access(at least 2007 allows this), you can save the import steps. This function allows you to semi-automate the import of the data. So unless you want a timed import function that is all you need do.
If you need the import fully automated, then you can utilize a Macro or Visual Basic to automate the import. Export steps can be saved as well. Hopefully one day, we will be able to export directly to a SqLite database. Scott T. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
