Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 85
  • Last Modified:

Access 2010 Freezes Trying to Import Excel Data

Did a search here, and all of the previous postings I could find were regarding using VBA or accessing a server.  My issue is far more simple: I cannot manually import a spreadsheet into Access.  I thought my spreadsheet was too big or complex or because it has some drop down selections, so I make a test spreadsheet with just three field headings and the number "1" in one row of data underneath; won't import that either.  I found a suggesting in a Google search to allow any and all macros for both Access and Excel; made no difference.  I'm hoping for something less disruptive than removing and reinstalling Access.

OS:  Windows 10-64
0
Mike Caldwell
Asked:
Mike Caldwell
  • 2
1 Solution
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
try this:
copy values from Excel including (only one) row of column labels. Then right-click in Navigation Pane of Access and choose Paste to make a new table (that can then do something with).

If that doesn't get it, copy selected information in Excel to a new sheet and Paste Values.  Then use the above  process or the standard import from Access (make sure Excel workbook is saved and closed).
0
 
Mike CaldwellDirector of Business Development, AnaquaAuthor Commented:
Good suggestion.  In the course of trying this I also just restarted the PC, and that fixed it.
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
You are welcome ~ glad you got it, Mike
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now