Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 63
  • 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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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