Forum Discussion
dealing with "Send a frown" in VBA
Hi everyone, Within MS Windows 10, MS Excel 365 using ODBD connectivity and SQL we extract transactional data from an accounting database using Excel's built-in Power Pivot editor. When data...
Just a question - why are you using ODBC? Excel in Office 365 can bypass that and connect directly to the SQL Server in Get & Transform. That might remove the failure altogether. I know it doesn't help with the issue you are trying to trap, but we use Excel with our SQL server all of the time and I haven't seen a frown face on a data refresh in ages.