Database Table Maintanance by Text File

From: Joachim Hofmann (speicher_at_freenet.de)
Date: 12/13/04 

Date: Mon, 13 Dec 2004 14:31:58 +0100

Hello,

I want to update a database table by a text file.

If the primary key in the text file also exists in the table, I want to update
all no primary key fields in the database with the corresponding fields of the text file.

If the primary key column in the text file ist empty, I want to have the line of the text file
being inserted into the table.

I tried several ways, but I dont know how to do this, I think this kind of task is confusing.

- Is this in general possible without using a temporary database table being filled first?

- What tasks are meaningful to do this? A normal data pump task; maybe with a lookup?
Or, do I need to use a data driven query, maybe with a lookup?

- Can somebody tell me a rough procedue to build this kind of task?

Thank You very much

Joachim

Relevant Pages

  • Re: problem using identity column as primary key
    ... >> I am thinking of creating an identity column to use it as primary key ... More and more programmers who have absolutely no database training are ... the gap in the sequence is not filled in and the sequence ... vin CHARNOT NULL REFERENCES Motorpool); ...
    (microsoft.public.sqlserver.programming)
  • Re: Updating the SQL key value
    ... before creating the database, by the time I've come to pick a primary key, ... articles, each of which must be issued under a particular licence (e.g. ... GPL GNU General Public Licence http://www.gnu ... ...
    (comp.lang.php)
  • Re: Concatenate and Null Values -- Features
    ... Tony Toews dislikes cascade deletes as well as cascade updates, ... fence regarding the use of natural versus surrogate (autonumber) keys. ... Database Normalization Tips ... For optimal database design and performance, the primary key of a table ...
    (microsoft.public.access.reports)
  • Re: Option groups, radio buttons and reports...oh my!!
    ... designing a 'questionnaire' database of using separate columns for the ... referencing the primary key of the Questions and Answers table. ... composite primary key of QuestionAnswers. ... a composite one of RespondentID and QuestionID; ...
    (microsoft.public.access.gettingstarted)
  • Re: simple database
    ... Into what component of the database did you enter over 100 ... The company's Employee ... ID number can be a primary key in that table, ... Possessors, and Transfers are the names he is using. ...
    (microsoft.public.access.gettingstarted)