Re: Re: MS Access data to PostgrSQL data
От | Adam Lang |
---|---|
Тема | Re: Re: MS Access data to PostgrSQL data |
Дата | |
Msg-id | 021601c08196$ceb1a500$330a0a0a@6014cwpza006 обсуждение исходный текст |
Ответ на | Re: Re: MS Access data to PostgrSQL data (Tim Uckun <tim@diligence.com>) |
Список | pgsql-general |
That's sort of the problem though... the person never quite mentioned where PHP was located. I agree with you though, If you have Access and postgreql, why write a whole new program in a third language to get the data over? There has to be other reasons if the person wants to make it that difficult. ;) Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com ----- Original Message ----- From: "Lamar Owen" <lamar.owen@wgcr.org> To: "Tim Uckun" <tim@diligence.com> Cc: <pgsql-general@postgresql.org> Sent: Thursday, January 18, 2001 3:25 PM Subject: Re: [GENERAL] Re: MS Access data to PostgrSQL data > Tim Uckun wrote: > > > > >>hi, > > >>can anyone help me ? i need to convert a ms access .mdb file into > > >>somthing readable so i can insert it into my postgreSQL db... > > >>does anyone have any experiance? (preferably using PHP) > > >>Robert Korteweg > > >>The Netherlands > > > > Here is your steps. > > 1) Create your destination table in postgres > > 2) Export your data to a comma delimeted format > > 3) save this perl script to a file > > Good script. > > But, if you have the PostgreSQL ODBC driver installed on the windows > machine, you can use Access's SaveAs/Export function to save it directly > into a PostgreSQL table. Although, that might be overkill for this, I > do this quite alot (did it five times today to get some data over to the > real RDBMS.....). > -- > Lamar Owen > WGCR Internet Radio > 1 Peter 4:11
В списке pgsql-general по дате отправления: