• Importing an Excel spreadsheet (2002)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Importing an Excel spreadsheet (2002)

    Author
    Topic
    WSJohn
    AskWoody Lounger
    January 28, 2008 at 2:51 am #448073

    Any idea why the attached Excel spreadsheet won’t import into Access?

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      January 28, 2008 at 8:00 am #1094595

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

      Reply | Quote
      • WSJohn
        AskWoody Lounger
        January 28, 2008 at 3:17 pm #1094638

        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.

        Reply | Quote
        • WSgrovelli
          AskWoody Lounger
          January 29, 2008 at 10:19 am #1094837

          Shall we throw a big bash in Hans’s honour in Iceland? hugs
          hello

          Reply | Quote
          • WSJohn
            AskWoody Lounger
            January 29, 2008 at 1:01 pm #1094855

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

            Reply | Quote
    Viewing 0 reply threads
    Reply To: Importing an Excel spreadsheet (2002)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.