Results 1 to 2 of 2
  1. #1
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664

    External Data Excel is grayed out

    In Ms Access when i start the key sequence to import and Excel spreadsheet, I go to External data at the of the screen. I click on it and everything is grayed out except
    "Saved Imports".



    My question is simple. How do i get the other icons to color themselves. Write now as I said they are grayed out and are unusable.

    How do I get them to be usable?

    Any help appreciated. Thanks in advance.

    Respectfully,

    Lou Reed

  2. #2
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    I have got this one. When I went back to MS Access 2016, I noticed after clicking on External data ,that Excel was not grayed out. In fact none of the icons were so I guess the issue is overcome by events.

    I do not know what happened, but clearly it is now working an this is no longer a problem.

    Thanks anyway.

    Respectfully,

    Lou Reed

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Importing External Data - Excel
    By maeyks in forum Access
    Replies: 1
    Last Post: 03-24-2016, 06:41 PM
  2. Replies: 5
    Last Post: 10-20-2015, 06:43 PM
  3. Replies: 1
    Last Post: 07-10-2015, 06:33 AM
  4. Macro to mimic Import & Link Excel button on external data
    By arnstrb in forum Import/Export Data
    Replies: 1
    Last Post: 03-16-2014, 07:52 PM
  5. Linking Access Table with already imported External Data (Excel)
    By izzarshah in forum Import/Export Data
    Replies: 1
    Last Post: 07-29-2010, 09:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums