ExternalData_1: Getting Data ...
is all I see when running.
I am using the ActiveSheet.ListObjects.Add() command, with .CommandText = "SQL STRING HERE"
I have debugged the macro, it runs, and enters "ExternalData_1: Getting Data ..." into the desired location but does not return data.
The query is confirmed working in MS SQL Server 2008 (taken the SQL directly from the working Macro and ran it in MS SQL to immediate results)
The macro is free of bugs, and running. I have confirmed it working by dropping in very simple 'Select top 10 * from table* statements, and had it return results.
Unfortunately my code is too long and possibly sensitive for me to edit and post it here. I am hoping this is enough information to go off of . . .
Edit: I am using this string method along with the .CommandText as the Excel 2010 macro records it, because other methods I have seen I cannot locate or identify the correct information I need to establish a connection. So that is likely out of the question.
Edit2: Perhaps there are methods in MS Sql 2008 that error/halt Ms Office 2010? My only guess is there is something incompatible, and I dont believe it is an excess of data if that is possible . . . I can easily pull more but with a simpler query. Its not a complicated query . . . 4 joins and no subqueries . . . just straight line query.