Excel - Unexpected Error when getting data from Access database

Question

I'm trying to get data in Excel from Access. I am able to get data from the web and from other Excel files, but it seems I can't get it from any Access file. The error is the following one. I did open the database in Access and had no problem doing so. It is a small sample file, so the size is not the issue. I've tried clearing the Power Query Cache and all these:

1.    Perform System File Checker (SFC) scan:

    i. Open CMD (Admin)

    ii. Type sfc /scannow and then press ENTER

2.    Fix Windows corruption errors by using the DISM:

    i. Open CMD (Admin)

    ii. Type the following commands in command prompt one by one and press Enter after each command:

      -      Dism /Online /Cleanup-Image /CheckHealth

      -      Dism /Online /Cleanup-Image /ScanHealth

      -      Dism /Online /Cleanup-Image /RestoreHealth

Restart your PC and check if the issue can be fixed.

• i did try this but nothing is change.
  -uninstall and install Microsoft office.
  -frequently restarting my pc 
  -lastly i make that my windows is up to date.

I've also checked the security settings in Excel and I have it in "Prompt user about Data Connections". The Access file I am trying to connect with gave me a warning when I first opened it: "some active content has been disabled". I enabled it but still can't get the data from Excel. I did import the data to Excel from Access and it worked, but I would like to fix this error. I should not have to open Access and import the data, I should be able to get the Data to Power Query directly. Is there a way to fix this issue? I've tried using a different Access file and the exact same thing happens. Both files are .accdb.

Thank you!

PS: I'm using Parallels, Excel is running on Windows.

Feedback Type:

Frown (Error)

Error Message:

Error

Stack Trace:

Stack Trace Message:

Error

Invocation Stack Trace:

at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)

at Microsoft.Mashup.Client.UI.Shared.IUIHostExtensions.RaiseErrorDialog(IUIHost uiHost, IWindowHandle activeWindow, FeedbackPackageInfo feedbackPackageInfo, Exception e, LocalizedString dialogTitle, LocalizedString dialogMessage, Boolean useGDICapture)

at Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)

at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()

at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)

at Microsoft.Mashup.Client.UI.Shared.DataImporter.HandleImportEvaluationException(ExceptionResult exceptionView, Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor)

at Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor)

at Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)

at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClass66_0.<GetPreviewResult>b__1()

at Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookStorageServices.Microsoft.Mashup.Client.Excel.Shim.IDeferredStorageInvoker.InvokeDeferredStorageAction(IWorkbook workbook, Action action)

at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.InvokeCoauthAction(IWorkbook workbook, UndoableActionType actionType, Action action)

at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.NotifyGetDataPresence(IWorkbook workbook, Action action)

at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClass60_0.<InvokeOnWorkbook>b__0(IWorkbook workbook, IWindowContext windowContext)

at Microsoft.Mashup.Client.Excel.ExcelDataImporter.InvokeOnWorkbookT

at Microsoft.Mashup.Client.Excel.ExcelDataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)

at Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass87_1.<OnQuerySettingsResolved>b__0()

at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

at System.Delegate.DynamicInvokeImpl(Object[] args)

at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)

at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)

at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)

at System.Windows.Forms.Control.InvokeMarshaledCallbacks()

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

InnerException0.Stack Trace Message:

Container exited unexpectedly with code 0xC0000409. PID: 8744.

Used features: (none).

InnerException0.Stack Trace:

at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()

at Microsoft.Mashup.Evaluator.ChannelMessenger.Read(MessageChannel channel)

at Microsoft.Mashup.Evaluator.ChannelMessenger.MessageChannel.Read()

at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitForT

at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)

at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_TableSource()

at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_TableSource()

at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult21 result, Func1 getStaleSince, Func`1 getSampled)

InnerException0.Invocation Stack Trace:

at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix)

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e)

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)

at Microsoft.Mashup.Client.UI.Shared.IUIHostExtensions.RaiseErrorDialog(IUIHost uiHost, IWindowHandle activeWindow, FeedbackPackageInfo feedbackPackageInfo, Exception e, LocalizedString dialogTitle, LocalizedString dialogMessage, Boolean useGDICapture)

at Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)

at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()

at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)

at Microsoft.Mashup.Client.UI.Shared.DataImporter.HandleImportEvaluationException(ExceptionResult exceptionView, Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor)

at Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor)

at Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)

at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClass66_0.<GetPreviewResult>b__1()

at Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookStorageServices.Microsoft.Mashup.Client.Excel.Shim.IDeferredStorageInvoker.InvokeDeferredStorageAction(IWorkbook workbook, Action action)

at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.InvokeCoauthAction(IWorkbook workbook, UndoableActionType actionType, Action action)

at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.NotifyGetDataPresence(IWorkbook workbook, Action action)

at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClass60_0.<InvokeOnWorkbook>b__0(IWorkbook workbook, IWindowContext windowContext)

at Microsoft.Mashup.Client.Excel.ExcelDataImporter.InvokeOnWorkbookT

at Microsoft.Mashup.Client.Excel.ExcelDataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)

at Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass87_1.<OnQuerySettingsResolved>b__0()

at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

at System.Delegate.DynamicInvokeImpl(Object[] args)

at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)

at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)

at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)

at System.Windows.Forms.Control.InvokeMarshaledCallbacks()

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

InnerException1.Stack Trace Message:

Container exited unexpectedly with code 0xC0000409. PID: 8744.

InnerException1.Stack Trace:

at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()

at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()

InnerException1.Invocation Stack Trace:

at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix)

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e)

at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)

at Microsoft.Mashup.Client.UI.Shared.IUIHostExtensions.RaiseErrorDialog(IUIHost uiHost, IWindowHandle activeWindow, FeedbackPackageInfo feedbackPackageInfo, Exception e, LocalizedString dialogTitle, LocalizedString dialogMessage, Boolean useGDICapture)

at Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)

at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()

at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)

at Microsoft.Mashup.Client.UI.Shared.DataImporter.HandleImportEvaluationException(ExceptionResult exceptionView, Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor)

at Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor)

at Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)

at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClass66_0.<GetPreviewResult>b__1()

at Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookStorageServices.Microsoft.Mashup.Client.Excel.Shim.IDeferredStorageInvoker.InvokeDeferredStorageAction(IWorkbook workbook, Action action)

at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.InvokeCoauthAction(IWorkbook workbook, UndoableActionType actionType, Action action)

at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.NotifyGetDataPresence(IWorkbook workbook, Action action)

at Microsoft.Mashup.Client.Excel.ExcelDataImporter.<>c__DisplayClass60_0.<InvokeOnWorkbook>b__0(IWorkbook workbook, IWindowContext windowContext)

at Microsoft.Mashup.Client.Excel.ExcelDataImporter.InvokeOnWorkbookT

at Microsoft.Mashup.Client.Excel.ExcelDataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)

at Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass87_1.<OnQuerySettingsResolved>b__0()

at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

at System.Delegate.DynamicInvokeImpl(Object[] args)

at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)

at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)

at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)

at System.Windows.Forms.Control.InvokeMarshaledCallbacks()

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Supports Premium Content:

True

Formulas:

section Section1;

shared #"Course List" = let

Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],

#"Changed Type" = Table.TransformColumnTypes(Source,{{"Course Code and Description", type text}, {"Category", type text}, {"Length", type text}}),

#"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Course Code and Description", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, false), {"Course Code and Description.1", "Course Code and Description.2"}),

#"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Course Code and Description.1", Int64.Type}, {"Course Code and Description.2", type text}}),

#"Renamed Columns" = Table.RenameColumns(#"Changed Type1",{{"Course Code and Description.1", "Course Code"}, {"Course Code and Description.2", "Course Description"}})

in

#"Renamed Columns";

shared #"Course Schedule" = let

Source = Excel.Workbook(File.Contents("C:\Users\mq20161829\Documents\Data Wrangling MOOC\Course3\Week1\Workbooks\Training Schedule.xlsx"), null, true),

Sheet1\_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],

#"Promoted Headers" = Table.PromoteHeaders(Sheet1\_Sheet, [PromoteAllScalars=true]),

#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Location", type text}, {"Date", type date}, {"Course Code", Int64.Type}, {"Course Name", type text}, {"Instructor Code", Int64.Type}, {"Room", type text}}),

#"Filled Down" = Table.FillDown(#"Changed Type",{"Location"})

in

#"Filled Down";

shared Staff = let

Source = Access.Database(File.Contents("\\Mac\Home\Downloads\New folder\Staff.accdb"), [CreateNavigationProperties=true])

in

Source;

[Move from: Microsoft 365 and Office / Excel / Unknown / Windows]

Answer 1

Thanks Snow Lu, will do!

Answer 2

Sign in to Microsoft 365 with your Microsoft 365 admin account, and select Support > New service request. If you're in the admin center, select Support > New service request.

Contact Microsoft Office Support - Microsoft Support

Answer 3

Hi Snow Lu,

Thanks for your quick reply. This is my first time trying to get data from Access. Could it be a setting in Access?

How do I raise a ticket to Microsoft?

Thanks!

Answer 4

Hi Maria,

Greetings! Thank you for posting to Microsoft Community.

Have you tried with get data from some access source before? If yes, it could be some office update caused this issue and the best way is to roll back to office to an older version.

This is my third time meet similar issue (Container exited unexpectedly with code 0xXXXXXXX. PID: XXXXX.), but none of them had been resolved.

I also checked from PID number to get the containers information but no result.

My suggestion is to raise a ticket to Microsoft to invest the issue. And temporary open access and import the data.

Best Regards,

Snow Lu