Welcome to SPN

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

Sign Up Now!

reimport existing table

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

  1. SandyR

    SandyR
    Expand Collapse
    Guest

    I have a frequently updated vendor table that I get from a legacy system. I
    would like to automatically reimport this table on a regular basis. I am
    hoping for some suggestions as how to go about this. Also, other tables
    relate to this table for vendor names. Does this impact the reimport process?
     
  2. Loading...

    Similar Threads Forum Date
    Legal Lok Pal Bill - Difference of Existing System & System proposed by Civil Society Breaking News Aug 20, 2011
    Non Existing 'I' Gurmat Vichaar Feb 19, 2008
    Sikh News Punjab govt to add 300 new buses to existing fleet (New Kerala) Breaking News Jun 29, 2007

  3. jahoobob via AccessMonster.com

    Guest

    Why not just link to it. Files that can be Imported and files that can be
    link are limited to the same file types. If you link your data will always
    be up-to-date. You link pretty much the same way as you import.

    SandyR wrote:
    >I have a frequently updated vendor table that I get from a legacy system. I
    >would like to automatically reimport this table on a regular basis. I am
    >hoping for some suggestions as how to go about this. Also, other tables
    >relate to this table for vendor names. Does this impact the reimport process?


    --
    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200606/1
     
  4. SandyR

    SandyR
    Expand Collapse
    Guest

    I can't link it because it comes from a completely incompatible system.

    "jahoobob via AccessMonster.com" wrote:

    > Why not just link to it. Files that can be Imported and files that can be
    > link are limited to the same file types. If you link your data will always
    > be up-to-date. You link pretty much the same way as you import.
    >
    > SandyR wrote:
    > >I have a frequently updated vendor table that I get from a legacy system. I
    > >would like to automatically reimport this table on a regular basis. I am
    > >hoping for some suggestions as how to go about this. Also, other tables
    > >relate to this table for vendor names. Does this impact the reimport process?

    >
    > --
    > Message posted via AccessMonster.com
    > http://www.accessmonster.com/Uwe/Forums.aspx/access/200606/1
    >
     
  5. jahoobob via AccessMonster.com

    Guest

    The file that you are currently importing must be a downloaded text file of
    some sort, or some other recognizable to Access format. If you copy over a
    file that is linked to an Access table, with a file that has the same
    structure but different data, the new data will be in your table and
    everything should work with the new data as well as it did with the old data.
    Do it this way and you avoid the import process.

    SandyR wrote:
    >I can't link it because it comes from a completely incompatible system.
    >
    >> Why not just link to it. Files that can be Imported and files that can be
    >> link are limited to the same file types. If you link your data will always

    >[quoted text clipped - 4 lines]
    >> >hoping for some suggestions as how to go about this. Also, other tables
    >> >relate to this table for vendor names. Does this impact the reimport process?


    --
    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200606/1
     
  6. SandyR

    SandyR
    Expand Collapse
    Guest

    Are you saying that I can link to a text file? If not, then I have to make
    it an access file somehow, don't I? I am confused.

    "jahoobob via AccessMonster.com" wrote:

    > The file that you are currently importing must be a downloaded text file of
    > some sort, or some other recognizable to Access format. If you copy over a
    > file that is linked to an Access table, with a file that has the same
    > structure but different data, the new data will be in your table and
    > everything should work with the new data as well as it did with the old data.
    > Do it this way and you avoid the import process.
    >
    > SandyR wrote:
    > >I can't link it because it comes from a completely incompatible system.
    > >
    > >> Why not just link to it. Files that can be Imported and files that can be
    > >> link are limited to the same file types. If you link your data will always

    > >[quoted text clipped - 4 lines]
    > >> >hoping for some suggestions as how to go about this. Also, other tables
    > >> >relate to this table for vendor names. Does this impact the reimport process?

    >
    > --
    > Message posted via AccessMonster.com
    > http://www.accessmonster.com/Uwe/Forums.aspx/access/200606/1
    >
     
  7. SandyR

    SandyR
    Expand Collapse
    Guest

    It took me a while, but I finally understood what you were trying to tell me.
    Linking to the text file works beautifully - I can replace the text file at
    will, and the link always points to the most recent one. Thanks!

    "jahoobob via AccessMonster.com" wrote:

    > The file that you are currently importing must be a downloaded text file of
    > some sort, or some other recognizable to Access format. If you copy over a
    > file that is linked to an Access table, with a file that has the same
    > structure but different data, the new data will be in your table and
    > everything should work with the new data as well as it did with the old data.
    > Do it this way and you avoid the import process.
    >
    > SandyR wrote:
    > >I can't link it because it comes from a completely incompatible system.
    > >
    > >> Why not just link to it. Files that can be Imported and files that can be
    > >> link are limited to the same file types. If you link your data will always

    > >[quoted text clipped - 4 lines]
    > >> >hoping for some suggestions as how to go about this. Also, other tables
    > >> >relate to this table for vendor names. Does this impact the reimport process?

    >
    > --
    > Message posted via AccessMonster.com
    > http://www.accessmonster.com/Uwe/Forums.aspx/access/200606/1
    >
     

Share This Page