Export data in excel sheet and in specific column

Question

Hi,

I want the following query to be exported in an excel sheet through VB
SELECT IPADDRESS FROM TRANSFER_MANAGER

I want IPADDRESS to be executed in the 3rd column in an excel sheet.

Can any body provide me the code for it.

Thanks in advance
Sneha