Connecting to SQL from Excel
 

Can any one tell me what is the correct function(s) to connect to a SQL 2000
Database, run a query, and put it in the spreadsheet using VBA for Excel
2000. Thanks for any help in advance.

Connecting to SQL from Excel
 

Look in the menu at Data=Get External Data (or equivalent)

--
Regards,
Tom Ogilvy

"Keith La Force" wrote in message
...
Can any one tell me what is the correct function(s) to connect to a SQL
2000
Database, run a query, and put it in the spreadsheet using VBA for Excel
2000. Thanks for any help in advance.

Connecting to SQL from Excel
 

Hi, yes I can do it through Data=Import Data in Excel, but I want to do it
programatically, through VBA.

"Tom Ogilvy" wrote:

Look in the menu at Data=Get External Data (or equivalent)

--
Regards,
Tom Ogilvy

"Keith La Force" wrote in message
...
Can any one tell me what is the correct function(s) to connect to a SQL
2000
Database, run a query, and put it in the spreadsheet using VBA for Excel
2000. Thanks for any help in advance.

Connecting to SQL from Excel
 

Not trying to be difficult but why in VBA. Unless you need to write back to
the database, there are very few good reasons to do it through code? You can
record a macro of Data=Import Data which is a whole lot easier than getting
into the ADO recordsets you need otherwise.

"Keith La Force" wrote:

Hi, yes I can do it through Data=Import Data in Excel, but I want to do it
programatically, through VBA.

"Tom Ogilvy" wrote:

Look in the menu at Data=Get External Data (or equivalent)

--
Regards,
Tom Ogilvy

"Keith La Force" wrote in message
...
Can any one tell me what is the correct function(s) to connect to a SQL
2000
Database, run a query, and put it in the spreadsheet using VBA for Excel
2000. Thanks for any help in advance.

Connecting to SQL from Excel
 

Hi, well I needed to do some complex string manipulation, but I figured out
how to do it. Thanks for all you help anyway.

"Jim Thomlinson" wrote:

Not trying to be difficult but why in VBA. Unless you need to write back to
the database, there are very few good reasons to do it through code? You can
record a macro of Data=Import Data which is a whole lot easier than getting
into the ADO recordsets you need otherwise.

"Keith La Force" wrote:

Hi, yes I can do it through Data=Import Data in Excel, but I want to do it
programatically, through VBA.

"Tom Ogilvy" wrote:

Look in the menu at Data=Get External Data (or equivalent)

--
Regards,
Tom Ogilvy

"Keith La Force" wrote in message
...
Can any one tell me what is the correct function(s) to connect to a SQL
2000
Database, run a query, and put it in the spreadsheet using VBA for Excel
2000. Thanks for any help in advance.