Macro to connect database

Hi,
I need to connect database with Excel using macros. I want to fetch data by running macros from Excel sheet and want to import data in excel.

Can anyone please help me in writing macro code to connect the database and extract data.
I have following database details with me :
User name : abctest
Password : ********
Host : abc408
TCP Port: 1234
SID : cq30

Please write a code using the dummy details provided above.
many thanks in advance for your help.

Thanks

Have a look at webqueries and databasequeries.