Select Data from SQL Server
 

Hi

No idea on how to do this.

Need to open a recordset from an SQL Server.

Basic details: server name Demo
Database Accounts
Username keyaccounts
password fish

What code would i need to use?

Regards

D

Select Data from SQL Server
 

This is the first hit when I Google for:
ado excel ms sql server
http://support.microsoft.com/kb/306125

I suppose you didn't know about ADO

RBS

"David McNaughton" wrote in message
...
Hi
No idea on how to do this.

Need to open a recordset from an SQL Server.
Basic details: server name Demo
Database Accounts
Username keyaccounts
password fish

What code would i need to use?

Regards

D