Received: from mailout5.nyroc.rr.com (mailout5-0.nyroc.rr.com [24.92.226.122]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1C1YYE95190 for ; Mon, 11 Feb 2002 20:34:34 -0500 (EST) (envelope-from coffej@rpi.edu) Received: from mail4.nycap.rr.com (mail4-1 [24.92.226.200]) by mailout5.nyroc.rr.com (8.11.6/Road Runner 1.12) with ESMTP id g1C1YGM05504 for ; Mon, 11 Feb 2002 20:34:18 -0500 (EST) Received: from computer ([24.169.221.138]) by mail4.nycap.rr.com (Post.Office MTA v3.5.3 release 223 ID# 0-59787U250000L250000S0V35) with SMTP id com for ; Mon, 11 Feb 2002 20:34:16 -0500 From: "RPI" To: Subject: help importing external excel file Date: Mon, 11 Feb 2002 20:33:14 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Importance: Normal X-Archive-Number: 200202/219 X-Sequence-Number: 6643 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