Accessing External Data

[Jon Kane]

I am using VBA in excel to query a microsofts sql server using odbc drivers
in order to bring all the information into an excel spreadsheet. I've been
running into some problems and am wondering what is the easiest way to go
about accomplishing this task. Thanks for the help.

--Jon

 

[David Price]

Jon,

It depends on what sort of problems you are encountering.

It could be that you need to create a Stored Procedure on the SQL Server so
that much of the data selectivity and pre-processing is done at the server
(often a lot faster than a PC), with only a table of the desired results
sent to Excel. (Might also help if you have network traffic issues)

I have used both - unfortunately, it does depend on the complexity of the
data sought and the errors encountered.

Regards

Dave