Need to append Excel data from daily email attachment into a single Excel sheet in Sharepoint
Each morning, I receive an email with an Excel attachment that includes our sales data for the previous day. There is only 1 tab. The email always has the same number of columns, with headers, but there are a dynamic number of rows. I manually open the Excel attachment, and copy all of the data - excluding the header row - and then paste those results into an Excel sheet in Sharepoint. This provides me a running total for historical reporting. How can I go about automating this process so when the email is received, the data within the attachment is automatically appended to the central sheet in Sharepoint? Thanks for your time!
Installed MySQL connector/NET 8.0.13 but still doesnt connect in Excel 2016
I'm trying to connect to MySQL database using Data > New Query > From Database > From MySQL Database However i am getting the error "This connector requires one or more additional components to be installed before it can be used" I have already installed the MYSQL Connector/NET 8.0.13 But i continue to get the error box in Excel I am using Excel 2016, 64 bit, with Professional Plus 2016 Any help would be appreciated thanks very much
How do you do a parameter query when not using Microsoft Query?
I've been scouring the internet for the better part of a week trying to figure this out, so I'm hoping there's an Excel/data ninja here that can help. Problem: I have several SQL queries embedded in my workbook, but need the end user to be able to pass values from cells to the query. For the most part, it'll be a couple of simple values, such as start date, end date, and username. Most of the solutions I've found say to go to Connection Properties > Definitions and add parameters, then add them to the query at the bottom of the box, but this field is always greyed out for me - whether it's regarding a Query or a connection. Additionally, the query I'm running is a monster (I'm trying to make the server do the processing rather than Excel on my local machine), so I need a solution that lets me pass values to a complex query, not just a single table. This can't be very difficult, but I can't for the life of me get any of the answers I've found to work. Also, many of the answers I've found on StackOverflow and other forums are 6+ years old. Attempted Solutions: https://www.experts-exchange.com/questions/28689038/Excel-SQL-Data-Connection-Reference-Cell-with-Date-Value.html was answered by telling the user to add parameters in the Connection Properties > Definitions> Command Text box. When I go there, that entire tab is grayed out. I've found ways to setup parameters, but can't figure out how to add them to the query without kicking a SQL error at runtime. This https://support.office.com/en-us/article/customize-a-parameter-query-addf7cb7-ddf0-442f-a60c-cd7280e201bd page has instructions that should be valid for my version of Excel (2016), but again, they suggest adding parameters and the entire Definitions tab is grayed out. (Also, the images in this page show the ribbon/icons with a blue background, which is from an older version of Excel. So, something was updated?) This post has what looks like the answer, but again, they're trying to edit the query in the Definitions tab, which I've also seen solutions that involved entering a string of code that looked like VBA code into the query, but those would always just cause syntax errors. I don't have any examples of these handy. What I'm hoping for: I would be eternally grateful for a simple explanation as to why the Definition tab is always grayed out, and a guide on how to make this work. I'm running Excel 2016 (Office365) and the SQL Server 2008. Thanks in advance!
Excel Version 1907 [Expression.Error] This native database query isn't currently supported
I have a file that contains a data connection that has been working for months. It recently stopped working after the 1907 update applied. Is anyone else experiencing an issue? How might I go about determining what part of the native query is causing the issue? I have also converted the query to a stored procedure and it doesn't work either. Is there a way to get more detailed error information?Excel 2016 Power Query crash
Hi, I've an issue with a workbook with a number of PowerQueries in it. It's started failing every time that the last query in the chain runs. Sometimes it will crash to desktop, others it will give me the opportunity to "Send a frown". Copy details in that dialog always returns the same information which I've pasted below. I've not provided the whole stack trace (I've read in other posts that it's only the first 10 or so rows that are relevant) but please let me know if you need more. Error Message: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. Stack Trace: at Microsoft.Mashup.Client.Excel.NativeExcelFunctionsMSI.Microsoft.Mashup.Client.Excel.INativeExcelFunctions.RefreshListObject(IntPtr workbookPointer, String listObjectName) at Microsoft.Mashup.Client.Excel.Shim.NativeListObject.TryRefresh() at Microsoft.Mashup.Client.Excel.ConnectionManager.<>c__DisplayClass19.<RefreshFillTargets>b__18() at Microsoft.Mashup.Client.Excel.Shim.NativeSafeInvoker.Invoke[T](Func`1 func) at Microsoft.Mashup.Client.Excel.ConnectionManager.RefreshFillTargets(IWorkbook workbook, Query query) at Microsoft.Mashup.Client.Excel.PollingFillManager.RefreshConnection(IWorkbook workbook, Query query) at Microsoft.Mashup.Client.Excel.Fill.FillManager.StartRefreshFill(IWindowHandle ownerWindow, IWorkbook workbook, Query query, IQueryServices queryServices) at Microsoft.Mashup.Client.Excel.ExcelQueryServices.<>c__DisplayClass6.<>c__DisplayClass8.<StartRefreshFill>b__5(IUndoScope scope) at Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.<>c__DisplayClass2.<InvokeUndoableAction>b__0() at Microsoft.Mashup.Client.Excel.Shim.AddInAndNativeCoAuthServicesMSI.InvokeCoauthAction(IWorkbook workbook, UndoableActionType actionType, Action action) Running on Office Pro Plus 2016 - Excel about dialog reports version 16.0.4849.1000. Any help much appreciated. JM
A Question about Power Query
I am looking for a Power Query Function that allows me to query a folder which has several excel files in it and return values located in specific Tables. In each excel File I have 2 Tables called "Table_1" & "Table_2". I want power query to return the values located in all of those tables (which are in the exact same format). So far, every article I find out there only talks about connecting to a folder and grabbing the raw excel data. I DO NOT WANT THAT. I want to specifically point the query to the above two mentioned tables ONLY. There could be other files in this folder I do not care about. For the life of my I cannot find any articles on this.
