Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page