help importing external excel file

From: "RPI" <coffej(at)rpi(dot)edu>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: help importing external excel file
Date: 2002-02-12 01:33:14
Message-ID: NEBBKBOMKLIOEAAHFPPBCEPLCDAA.coffej@rpi.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I am fairly new to SQL - can anyone give me advice on how to import new data
only from an external excel file. The data for the excel file will change
approximately a few times per week.

I have been trying to schedule a DTS import but will this check for existing
data - I do not want to import duplicate rows, can I run this someother
way - instead of scheduling to run every day can I have it run only when
changes are made to the file?

I would appreciate any advice on how to accomplish this.

Thanks

joann

Browse pgsql-sql by date

  From Date Subject
Next Message Keith Keller 2002-02-12 02:23:43 obtaining row number of select
Previous Message Tom Lane 2002-02-12 01:18:22 Re: UNION and rows improperly unified: query optimization question