Welcome to SPN

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

Sign Up Now!

How do I modify field names when importing data from text files

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

  1. manimalrud

    manimalrud
    Expand Collapse
    Guest

    I'm trying to import data from text file to access 2003, everything is fine
    but I can't modify the field names, where it says " Select fields in the area
    below, you can then modify field information in the "Field Options"
    area.........well it only allow me modify field 1, when I click the are below
    fields 2,3,etc, it doesn't change, always show field 1 and it's the onlyone
    that changes.....

    How can I solve this problem???

    I'd appreciate your answer as soon as you can.....thanks
     
  2. Loading...


  3. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    Instead of importing directly into a "final" Access table, import to a
    "temporary" table in Access. Then create an append (or an update) query
    that reads the temporary data, transforms and/or normalizes as needed, and
    appends/updated to your permanent table(s). This also gives you a way to
    resolve the typically un-normalized Excel data structure.

    Regards

    Jeff Boyce
    Microsoft Office/Access MVP


    "manimalrud" <manimalrud@discussions.microsoft.com> wrote in message
    news:9DE05D8A-11B7-4764-A385-EB8946F3101D@microsoft.com...
    > I'm trying to import data from text file to access 2003, everything is
    > fine
    > but I can't modify the field names, where it says " Select fields in the
    > area
    > below, you can then modify field information in the "Field Options"
    > area.........well it only allow me modify field 1, when I click the are
    > below
    > fields 2,3,etc, it doesn't change, always show field 1 and it's the
    > onlyone
    > that changes.....
    >
    > How can I solve this problem???
    >
    > I'd appreciate your answer as soon as you can.....thanks
     
  4. Graham Mandeno

    Graham Mandeno
    Expand Collapse
    Guest

    I have not seen this happen before.

    Try clicking on the "Advanced..." button. From there you can see all the
    field properties from a single screen and change them as required. You can
    also save the definition as an "Import specification" which can be used over
    and over again.
    --
    Good Luck!

    Graham Mandeno [Access MVP]
    Auckland, New Zealand

    "manimalrud" <manimalrud@discussions.microsoft.com> wrote in message
    news:9DE05D8A-11B7-4764-A385-EB8946F3101D@microsoft.com...
    > I'm trying to import data from text file to access 2003, everything is
    > fine
    > but I can't modify the field names, where it says " Select fields in the
    > area
    > below, you can then modify field information in the "Field Options"
    > area.........well it only allow me modify field 1, when I click the are
    > below
    > fields 2,3,etc, it doesn't change, always show field 1 and it's the
    > onlyone
    > that changes.....
    >
    > How can I solve this problem???
    >
    > I'd appreciate your answer as soon as you can.....thanks
     

Share This Page