Results 1 to 2 of 2

Thread: field Names

  1. #1
    Join Date
    Nov 2005
    Posts
    1

    Unanswered: field Names

    Please can someone help, I am trying to import external data and running an edit query in excel 2003 the original spreadsheet was created in excel 2000, when i run the import it removes the field names that were present and changes them from these:
    DATE HOUR SERVER AGENT_NAME RESP_TIME VOLUMES


    To

    1 2 Host AGENT_NAME 5 6

    How do I get this to keep the original field names

  2. #2
    Join Date
    Feb 2004
    Posts
    533
    Quote Originally Posted by legal
    How do I get this to keep the original field names
    Check your 'Data Range Properties' Options. Make sure 'Include Field Names' is checked in the Data Formating and Layout section.

    If your still having problems convert the data source, and control workbooks to Excel 2003 format and reconstruct the External Data query.
    ~

    Bill

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •