At 02:31 PM 6/23/00 -0500, you wrote: >On Fri, 23 Jun 2000, Troy A. Johnson wrote: >I could install PostgreSQL on the Web server and do a nightly mirror of the >Access tables to Postgres. The problem is that I don't know how to do this >step. Whatever anyone else tells you about previous steps,... When you get to the part about uploading to PostGres remember the SQL: LOAD DATA INFILE <filename> INTO <tablename> If PostGress doesn't allow LOAD DATA INFILE... then switch and use MySQL. You may have to upgrade as this is a recently accepted addition to SQL as far as I can tell. The best discussion I have EVER seen on LOAD DATA INFILE ... is in the DeBOIS book on MySQL. Also there is a phpMyAdmin which is web page based which SHOULD work to make your life a LOT easier. And last, though I haven't done it yet, the whole process might be automated with a perl script.... where you just skip the ACCESS database step. I hope at least some of this helps.... gs ****************************************** George Swan Collection Development Support Unit VOICE: (612) 624-5860 Room 170B, Wilson Library FAX: (612) 626-9353 University of Minnesota Libraries g-swan at tc.umn.edu 309 19th Avenue South cdm-web at tc.umn.edu Minneapolis, MN 55455 colldev at tc.umn.edu USA http://staff.lib.umn.edu/cdm/ --------------------------------------------------------------------- To unsubscribe, e-mail: tclug-list-unsubscribe at mn-linux.org For additional commands, e-mail: tclug-list-help at mn-linux.org