On Mon, Nov 04, 2002 at 14:20:49 +0100,
papapep <papapep(at)gmx(dot)net> wrote:
> How can I populate a database with data I've got in a spreadsheet
> without having to format it with all the terrible format with commas,
> sql orders and so on??
> Or, at least, which is the easiest way to do it?
Normally using \copy in psql will work fairly well with csv or tsv files.
If you need to process the data before loading it into tables, you might
consider using perl. It is fairly easy to massage dta and you can use
COPY statements to do the actual loads.