Accessing External Data
 

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

Accessing External Data
 

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


"Jon Kane" wrote in message
...
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