Re: converting .xls to delimited file - Mailing list pgsql-general

From Brian E. Pangburn
Subject Re: converting .xls to delimited file
Date
Msg-id 93hlo8$2bc7$1@news.tht.net
Whole thread Raw
In response to converting .xls to delimited file  (William Staniewicz <wstan@localhostnl.demon.nl>)
List pgsql-general
Excel 2000 has two options:
1. Select "Save-As" and then select "Save at type" = "Text (Tab delimited)"
2. Select "Save-As" and then select "Save at type" = "CSV (Comma delimited)"

If I remember correctly, earlier versions of Excel have similar options.

Hope this helps.

Brian E. Pangburn

"William Staniewicz" <wstan@localhostnl.demon.nl> wrote in message
news:200101101026.f0AAQfB16474@mail.postgresql.org...
> Is there any way to convert an Excel file (".xls")
> to a delimited file? Maybe using sed?
>
> Bill
>



pgsql-general by date:

Previous
From: Martin Weinberg
Date:
Subject: Copying an index from one copy of a database to another
Next
From: Martin Lillepuu
Date:
Subject: Re: converting .xls to delimited file