Cannot import Access database table in Excel

[nmmahajan]

Hi,

I am using Excel 2013. I am trying to import an Access database table in excel sheet, using 'DATA --> Get External Data --> From Access'. I get no response from either Excel or Access about the import.

Please help. Thanks in advance for the help.

Niteen

 

[ranman256]

And you entered all the connection paths in the connections?

 

[nmmahajan]

And you entered all the connection paths in the connections?

Do I need to use connections to import Access? As per tutorial available on Microsoft site (https://support.office.com/en-us/ar...ta-model-4b4e5ab4-60ee-465e-8195-09ebba060bf0), one needs to just follow the sequence of actions available on the ribbon to import (as I mentioned in my post), ''DATA --> Get External Data --> From Access".

 

[welshgasman]

No you do not.
I've just done this successfully in 2007.

I'd look at eventvwr (Start/Run) and see if that shows anything amiss.

Also try a repair of office and from the Administrator command window sfc /scannow

 

[james_lankford]

also check your anti-virus program

you can't believe how many times "Cylance Protect" has stopped me from importing files into and out of excel and access