Welcome to SPN

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

Sign Up Now!

Importing data from text file to already existing access file

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

  1. Pooja

    Pooja
    Expand Collapse
    Guest

    I imported data from a text file by making use of 'Get external
    data'..'Import' & then defining the corresponding feilds. Now i tried adding
    another text file of the same kind, but i had to define all the fields again.
    Is there any way that i can import the data from the text file directly to
    the already existing access file?

    I appriciate your help.Thanks!!
    -Pooja
     
  2. Loading...


  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 13 Jun 2006 15:24:01 -0700, Pooja
    <Pooja@discussions.microsoft.com> wrote:

    >I imported data from a text file by making use of 'Get external
    >data'..'Import' & then defining the corresponding feilds. Now i tried adding
    >another text file of the same kind, but i had to define all the fields again.
    >Is there any way that i can import the data from the text file directly to
    >the already existing access file?


    One way is to use File... Get External Data... Link, and then run an
    Append query into your existing table.

    John W. Vinson[MVP]
     

Share This Page