Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error message when importing file (2003)

    On trying to import a file into Access l am getting an error, see attachment for error and file l am importing.
    Any help would be appreciated.

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Error message when importing file (2003)

    You have two columns in the Excel file with column heading "Renewal Date". That is why you get the error you get.
    Regards
    John



  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Error message when importing file (2003)

    In fact there are duplicate field names throughout , POP Name, POP address, Tier about 5 times site ID about 5 times, line speed

    It appears that these have been cut and pasted side by side...this needs to be reviewed
    Jerry

Posting Permissions

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