Re: MS ACCESS -> PGSQL

On Thu, Nov 23, 2000 at 01:21:15PM +0100, Enrico Comini wrote: > I have a customer that works on a MDB database. urk. > There is a simple way to port data in the PGSQL database in his site ? importing schema will be more painful than data, i'd guess. data is easy: * save each table as .csv format from access * import them into excel and save as tab delimited * make sure the file has unix linebreaks * delete the first row (containing field names) * possibly empty the existing table in pg - DELETE FROM tablename; * import into pg - COPY tablename FROM '/tmp/foo.tab'; this is harder i guess if you don't have excel... the versions of access we've dealt with here didnt seem to have a 'save as tab delimited' feature. if newer versions do i guess you've got it even easier. i think this is one of the truly useful features of excel. its great for mashing bits of data about. j. -- .----------+------------------------------------. |John Slee `-----------. <john@chirp.com.au>| |Chirp Web Design | http://www.chirp.com.au| |Phone: +61 2 62301871 `----. +61 2 62301515 Fax| `---------------------------+-------------------'