Data import question - SQL - Microsoft SQL Server

Hello all...

I have a (probably very) easy question for the SQL experts here...

Lets say I have a table with the following rows and data:

Expand|Select|Wrap|Line Numbers

  Name       Nickname   Middlename

------------------------------------------------

Rodney    Rod            Bob

Now... I want to do an import of new data from a raw text file (or whatever)... that's easy... but is it possible to import the data into the table so that if there is a matching file like the one above, that file will be omitted? In other words, here's what my incoming data looks like before I import it:

Expand|Select|Wrap|Line Numbers

 Tom         Joe            Wayne

Rodney    Rod            Bob

Jim          Jack           Luis

Rodney    Carl            Bob

So... when I import the data I would end up with the following data in my table:

Expand|Select|Wrap|Line Numbers

 Name       Nickname   Middlename

------------------------------------------------

Rodney    Rod            Bob

Tom         Joe            Wayne

Jim          Jack           Luis

Rodney    Carl            Bob

The ONE true duplicate would be omitted...

I know this must be simple... any help???

Sep 20 '07 #1

Subscribe Post Reply

1118

ck9663

2,878

Expert 2GB

Hello all...

I have a (probably very) easy question for the SQL experts here...

Lets say I have a table with the following rows and data:

Expand|Select|Wrap|Line Numbers

Name       Nickname   Middlename

------------------------------------------------

Rodney    Rod            Bob

Now... I want to do an import of new data from a raw text file (or whatever)... that's easy... but is it possible to import the data into the table so that if there is a matching file like the one above, that file will be omitted? In other words, here's what my incoming data looks like before I import it:

Expand|Select|Wrap|Line Numbers

Tom         Joe            Wayne

Rodney    Rod            Bob

Jim          Jack           Luis

Rodney    Carl            Bob

So... when I import the data I would end up with the following data in my table:

Expand|Select|Wrap|Line Numbers

Name       Nickname   Middlename

------------------------------------------------

Rodney    Rod            Bob

Tom         Joe            Wayne

Jim          Jack           Luis

Rodney    Carl            Bob

The ONE true duplicate would be omitted...

I know this must be simple... any help???

if you can't do this on DTS, try uploading your text on a separate table then do the cleaning using query instead.

Sep 21 '07 #2

Similar topics

More question on Data Auto Import

by: Dan | last post by:

Could someone please help me with auto importing a series of data files into an Access table. I tried to follow code given below in a previous messagebut i'm getting error messages. Here's my...

Microsoft Access / VBA

Importing data from excel via command button on a form.

by: Mr. Bungle | last post by:

When importing excel from access I am fully aware that one can import directly into a table. Can you get as specific via code or something to import data from an excel sheet to a FORM (Not Table)...

Microsoft Access / VBA

importing data

by: harry | last post by:

Hi Folks: I'm trying to do something that looks simple, but I can't make it work right. It's Access 2000 on a Win2000 computer. I create a database with 5 columbs. The data I need to import...

Microsoft Access / VBA

Importing data from an External DB & Efficiency

by: Sara | last post by:

Hi - I've been reading the posts for a solution to my query, and realize that I should ask an "approch" question as well. We receive our production data from a third party, so my uers import...

Microsoft Access / VBA

Code completion / compact DB from code / slice data ???

by: Greg Strong | last post by:

Hello All, I've written code in a test database with test data. Everything seems to be working except compact database in VB code per http://www.mvps.org/access/general/gen0041.htm. The reason I...

Microsoft Access / VBA

255 Character Limit for Linked Excel data

by: Grip | last post by:

Hi, I have gone throught the group and Microsoft's online help and have seen many suggestions but I am still seeking clarity: 1. I have an excel spreadsheet. Column A contains text that may...

Microsoft Access / VBA

import data.py using massive amounts of memory

by: Nick Craig-Wood | last post by:

I've been dumping a database in a python code format (for use with Python on S60 mobile phone actually) and I've noticed that it uses absolutely tons of memory as compared to how much the data...

Python

import data from csv file

by: a | last post by:

Dear friends I want import data from CSV file to mdb file How can I do that in vb.net?

Visual Basic .NET

Retrieve data from Database using struts jsp

by: lifeisgreat20009 | last post by:

I am a newbie to Struts and JSP...I have been working on the code below for 5 hours now..I googled a lot but couldn't get much help so finally I am here.. Hoping of getting my problem solved. Please...

Java

Play with image A Technique in Java - Search image, Convert image to text , Hide data

by: Debadatta Mishra | last post by:

Introduction In this article I will provide you an approach to manipulate an image file. This article gives you an insight into some tricks in java so that you can conceal sensitive information...

Java

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server