Hi,

Im using openrow set on SQL server 2005, to pull back data from an Oracle database (I have SQL2005 but have no access to the Oracle DB only a username and password)

The process works great to pull back information, but what it doesn't do is include the column headers, is there an easy way to do this?

The code looks like this at present

SELECT * from OPENROWSET ('OraOLEDB.Oracle','ABC';'ME';'PASSWORD',
' My sql statement
')

I'd appreciate any help with this, even if it's no you cant do that!

Thanks