Welcome to SPN

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

Sign Up Now!

Importing text files to another database

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

  1. BD

    BD
    Expand Collapse
    Guest

    It's possible do Import text files to another database directly?
    I'm working with front end and I want to call the TransferText to
    import the file to the back end database. Or I must to import to the
    front end and then transfer the table to the back end and after that
    delete the table in the front end?

    []'s
    BD
    []'s
    BD
     
  2. Loading...

    Similar Threads Forum Date
    Malaysia Hindus, Sikhs In Malaysia Appalled With University Textbook Ridiculing Their Faiths Breaking News Jun 14, 2016
    Hard Talk Taking One Liners Out Of Context From Gurbani To Allow Intellectual Independence? Hard Talk Apr 23, 2016
    India Protests in India Over the Desecration of a Holy Text Leave Two Dead Breaking News Oct 16, 2015
    Learn Punjabi Convert Punjabi text Language, Arts & Culture Oct 11, 2013
    Sikh Coalition Harmeet Kaur Took the Lead ! First to Respond to Textbook Challenge ! Sikh Organisations May 25, 2013

  3. Martin

    Martin
    Expand Collapse
    Guest

    Create a new table in your back end, then import the text file by File | Get
    External Data | Import.

    After the data has been imported, go to your front end and link tables by
    File | Get External Data | Link Tables. Find your backend and new table with
    imported data.

    Hope this helps

    Martin



    "BD" wrote:

    > It's possible do Import text files to another database directly?
    > I'm working with front end and I want to call the TransferText to
    > import the file to the back end database. Or I must to import to the
    > front end and then transfer the table to the back end and after that
    > delete the table in the front end?
    >
    > []'s
    > BD
    > []'s
    > BD
    >
     
  4. BD

    BD
    Expand Collapse
    Guest

    Thanks Martin I really didn't expose my question correctly, sorry.
    I know do that like you mentioned. I mean how can I do the import into
    another database through code (VBA) from the front end? After that I
    know how to link the table from the back end to front end.

    []'s
    BD


    On Sat, 17 Jun 2006 04:13:01 -0700, Martin
    <Martin@discussions.microsoft.com> wrote:

    >Create a new table in your back end, then import the text file by File | Get
    >External Data | Import.
    >
    >After the data has been imported, go to your front end and link tables by
    >File | Get External Data | Link Tables. Find your backend and new table with
    >imported data.
    >
    >Hope this helps
    >
    >Martin
     

Share This Page