Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Import Excel Sheet (Access 2K/XP)

    Good morning all,

    I am having an extremely difficult time importing the attached worksheet into Access. I have renamed and reformatted all cells, but to no avail. Any guidance would be greatly appreciated
    Attached Files Attached Files

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import Excel Sheet (Access 2K/XP)

    I converted the spreadsheet to .txt, tab delimited and was able to import. Hope this helps someone else.

  3. #3
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Import Excel Sheet (Access 2K/XP)

    There appears to be something wrong with the header row. I renamed each of the column headings, then saved it and it imported fine into Access 2k and 2003.

  4. #4
    2 Star Lounger
    Join Date
    May 2001
    Location
    Omaha, NE USA, Nebraska, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import Excel Sheet (Access 2K/XP)

    Cell E1 had a space before the word Status that was causing the import issue.

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import Excel Sheet (Access 2K/XP)

    Thanks to both of you for your replies. I knew something was awry but couldn't see the forest for the trees. Probably explains why the .txt imported. Thanks again.

Posting Permissions

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