Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    St. Marys, Ontario, Canada
    Posts
    270
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing an Excel spreadsheet (2002)

    Any idea why the attached Excel spreadsheet won't import into Access?
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Importing an Excel spreadsheet (2002)

    There are some entries that contain quotes <code>"</code>. This throws Access off. If you remove the quotes in Excel (i.e. replace them with nothing), the sheet can be imported.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    St. Marys, Ontario, Canada
    Posts
    270
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing an Excel spreadsheet (2002)

    Hans, yet another success story. I got rid of the quotations and found that amperands (&) and number signs (#) didn't make Access too happy either.

    One day, I would like to meet the person behind the answers. You never cease to amaze me with your knowledge. I often say that using Access is like three-dimensional chess. Well, you are the Bobby Fischer of Access.

    Thanks a lot.

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing an Excel spreadsheet (2002)

    Shall we throw a big bash in Hans's honour in Iceland? <img src=/S/hugs.gif border=0 alt=hugs width=41 height=25>
    <img src=/S/hello.gif border=0 alt=hello width=25 height=29>

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    St. Marys, Ontario, Canada
    Posts
    270
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing an Excel spreadsheet (2002)

    Sounds like a great plan! It's a bit far from Canada, though.

Posting Permissions

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