Excel VBA SQL connection

[jag7777777]

Hi Everyone,

Could somebody help me please with the code that I need to gain a connection with a SQL server? Assuming the following:

Server Name: Server
DB Name: DB
Login name: login
Password: password

Could someone please post what the procedure would look like in VBA so I could run a SELECT * FROM TABLE script.

Could you also please post how I could make this appear in a particular worksheet in a particular range within a workbook if I put this code in a standard module.

Thanks in advance,

 

[SkipVought]

Hi,

This ought to be posted in forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}