Welcome to SPN

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

Sign Up Now!

Importing Excel--Changing Field Names

Discussion in 'Information Technology' started by acbc66, Nov 1, 2005.

  1. acbc66

    acbc66
    Expand Collapse
    Guest

    I'm importing some excel spreadsheets into Access 2002. The first row of
    data contains contains column headings, and I'm importing into a new table.
    The import spreadsheet wizard apparently gives me the option of changing the
    field names (which default to column headings) in my new table, but I can
    only change the name of the first field (column). When I highlight on later
    columns, the only field name I can change remains the first one.
     
  2. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    Do you have MS Office XP SP-3 installed? If so, the problem was caused by
    Office XP SP-3. There's an Office XP post-Service Pack 3 hotfix available,
    but you'll have to contact Microsoft's Product Support Services to get it.
    Check out the KB article about the hotfix here:

    http://support.microsoft.com/default.aspx?kbid=841365

    HTH.
    Gunny

    See http://www.QBuilt.com for all your database needs.
    See http://www.Access.QBuilt.com for Microsoft Access tips.

    (Please remove ZERO_SPAM from my reply E-mail address so that a message will
    be forwarded to me.)
    - - -
    If my answer has helped you, please sign in and answer yes to the question
    "Did this post answer your question?" at the bottom of the message, which
    adds your question and the answers to the database of answers. Remember that
    questions answered the quickest are often from those who have a history of
    rewarding the contributors who have taken the time to answer questions
    correctly.


    "acbc66" wrote:

    > I'm importing some excel spreadsheets into Access 2002. The first row of
    > data contains contains column headings, and I'm importing into a new table.
    > The import spreadsheet wizard apparently gives me the option of changing the
    > field names (which default to column headings) in my new table, but I can
    > only change the name of the first field (column). When I highlight on later
    > columns, the only field name I can change remains the first one.
     
  3. acbc66

    acbc66
    Expand Collapse
    Guest

    Looks as if that's it, thanks. I'll get the hotfix.

    "'69 Camaro" wrote:

    > Do you have MS Office XP SP-3 installed? If so, the problem was caused by
    > Office XP SP-3. There's an Office XP post-Service Pack 3 hotfix available,
    > but you'll have to contact Microsoft's Product Support Services to get it.
    > Check out the KB article about the hotfix here:
    >
    > http://support.microsoft.com/default.aspx?kbid=841365
    >
    > HTH.
    > Gunny
    >
    > See http://www.QBuilt.com for all your database needs.
    > See http://www.Access.QBuilt.com for Microsoft Access tips.
    >
    > (Please remove ZERO_SPAM from my reply E-mail address so that a message will
    > be forwarded to me.)
    > - - -
    > If my answer has helped you, please sign in and answer yes to the question
    > "Did this post answer your question?" at the bottom of the message, which
    > adds your question and the answers to the database of answers. Remember that
    > questions answered the quickest are often from those who have a history of
    > rewarding the contributors who have taken the time to answer questions
    > correctly.
    >
    >
    > "acbc66" wrote:
    >
    > > I'm importing some excel spreadsheets into Access 2002. The first row of
    > > data contains contains column headings, and I'm importing into a new table.
    > > The import spreadsheet wizard apparently gives me the option of changing the
    > > field names (which default to column headings) in my new table, but I can
    > > only change the name of the first field (column). When I highlight on later
    > > columns, the only field name I can change remains the first one.
     
  4. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    You're welcome.

    Gunny

    See http://www.QBuilt.com for all your database needs.
    See http://www.Access.QBuilt.com for Microsoft Access tips.


    "acbc66" <acbc66@discussions.microsoft.com> wrote in message
    news:67CF2A7F-E4E4-43F8-87D3-E06C48C2FFD7@microsoft.com...
    > Looks as if that's it, thanks. I'll get the hotfix.
    >
    > "'69 Camaro" wrote:
    >
    >> Do you have MS Office XP SP-3 installed? If so, the problem was caused
    >> by
    >> Office XP SP-3. There's an Office XP post-Service Pack 3 hotfix
    >> available,
    >> but you'll have to contact Microsoft's Product Support Services to get
    >> it.
    >> Check out the KB article about the hotfix here:
    >>
    >> http://support.microsoft.com/default.aspx?kbid=841365
    >>
    >> HTH.
    >> Gunny
    >>
    >> See http://www.QBuilt.com for all your database needs.
    >> See http://www.Access.QBuilt.com for Microsoft Access tips.
    >>
    >> (Please remove ZERO_SPAM from my reply E-mail address so that a message
    >> will
    >> be forwarded to me.)
    >> - - -
    >> If my answer has helped you, please sign in and answer yes to the
    >> question
    >> "Did this post answer your question?" at the bottom of the message, which
    >> adds your question and the answers to the database of answers. Remember
    >> that
    >> questions answered the quickest are often from those who have a history
    >> of
    >> rewarding the contributors who have taken the time to answer questions
    >> correctly.
    >>
    >>
    >> "acbc66" wrote:
    >>
    >> > I'm importing some excel spreadsheets into Access 2002. The first row
    >> > of
    >> > data contains contains column headings, and I'm importing into a new
    >> > table.
    >> > The import spreadsheet wizard apparently gives me the option of
    >> > changing the
    >> > field names (which default to column headings) in my new table, but I
    >> > can
    >> > only change the name of the first field (column). When I highlight on
    >> > later
    >> > columns, the only field name I can change remains the first one.
     

Share This Page