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...