TCLUG Archive
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [TCLUG:19135] Access to PostgreSQL via ODBC?



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@tc.umn.edu
309 19th Avenue South			cdm-web@tc.umn.edu
Minneapolis, MN 55455			colldev@tc.umn.edu
USA						http://staff.lib.umn.edu/cdm/