Import update from files in a directory

[Vishu]

Hi,
I have a series of DEL data files in a directory. Is there a way I can
import with update option the files directly from the directory into a
database? Thanks

[Ian]

Vishu wrote:

Hi,
I have a series of DEL data files in a directory. Is there a way I can
import with update option the files directly from the directory into a
database? Thanks

If your table has a primary key (and this data exists in your delimited
text files), you can use the IMPORT utility with the INSERT_UPDATE
operation.

Example:

import from your_file of del insert_update into your_table
This will update rows that already exist (where the primary key matches
the data in your input file), and insert records where the primary key
field in your file does not exist in the table.

Good luck,


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----