Query Sybase Database Directly from Excel using Visual Basic

[Galore]

Hi All,

I am a new member.

I am trying to run a query (e.g. select * from SybaseTable where SybaseCol = '12') directly from Excel.

I am hoping to be able to define the Data Source (define DSN, ServerName and DatabaseName), Open the Connection (enter SybaseID and SybasePassword) , and run the query automatically using Visual Basic....and then paste the results in an Excel Worksheet.

Can anyone tell me how to go about this?

Thanks