In Excel I using a Data Table that connects via a data connection string to an sql server procedure. The procedure accepts some parameters querys and then returns the data to the excel data table. This has worked well for quite a while.In Excel I using a Data Table that connects via