RE: converting .xls to delimited file
От | Jeff Eckermann |
---|---|
Тема | RE: converting .xls to delimited file |
Дата | |
Msg-id | 08CD1781F85AD4118E0800A0C9B8580B09488E@NEZU обсуждение исходный текст |
Ответ на | converting .xls to delimited file (William Staniewicz <wstan@localhostnl.demon.nl>) |
Список | pgsql-general |
Excel can do this for you, if you use File -> Save As... You will find various file types available. The list will vary according to the completeness of your Excel installation. I believe that at minimum you should have "tab delimited text" available, and probably csv as well (don't use csv, it's evil). If I'm wrong, you'll need to get the MS Office CD and reinstall Excel with more options checked... If you want to import the result into Postgres, beware of CR characters, and leading/trailing spaces in your fields. Excel will tolerate those spaces in non text-type fields, but Postgres will not. > -----Original Message----- > From: William Staniewicz [SMTP:wstan@localhostnl.demon.nl] > Sent: Wednesday, January 10, 2001 10:23 AM > To: pgsql-general@postgresql.org; pgsql-novice@postgresql.org > Subject: [GENERAL] converting .xls to delimited file > > Is there any way to convert an Excel file (".xls") > to a delimited file? Maybe using sed? > > Bill
В списке pgsql-general по дате отправления: