Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

recreating a table on a daily basis

Discussion in 'Information Technology' started by SandyR, Jul 28, 2006.

  1. SandyR

    SandyR
    Expand Collapse
    Guest

    I have a table of vendors that is based on a frequently updated table in
    another incompatible database. I can create a textfile of the vendors from
    the other data base and import it, but I haven't figured out how to automate
    that. Also, the table I am recreating has other tables linked to it. What
    happens to these links when I recreate the table? Does anyone have any
    suggestions as to what I should do?
     
  2. Loading...

    Similar Threads Forum Date
    As A Child, Public Marches Of Sikhism Made Me Uncomfortable. They Still Do . Why ? Whats The Logic Hard Talk Oct 16, 2016
    Arts/Society Backyard Vegetable Garden Language, Arts & Culture Dec 27, 2013
    Heritage Now a Vegetable Market, Ranjit Singh's Royal Haveli a Picture of Neglect History of Sikhism Nov 11, 2013
    Sikhism Helium: 1984 and the "Periodic Table of Hate" (Jaspreet Singh) Book Reviews & Editorials Oct 28, 2013
    Heritage How our entire history was dumped in a horse stable History of Sikhism Oct 28, 2013

  3. Ron2006

    Ron2006
    Expand Collapse
    Guest

    Don't delete the table, just empty it.

    Use transfertext to import the text file into a dummy table
    Then write an append query to read the dummy table and add records to
    your table.

    If there are other linked tables, you may end up with orphaned links if
    the reference is not reloaded. And if the other tables are normalized
    then you have an even harder problem since essentially you have
    destroyed the links.

    Basically we are saying we need more information in order to describe
    what will happen.

    Ron
     

Share This Page