none
How do I stop column names being returned? RRS feed

  • Question

  • Hi

    I'm using an SQL SELECT statement embedded within an Excel VBA macro to pull data out of an SQL database. It works fine except the first line I get back from the query is the column names but I don't want these, I just want the data.

    It would be really great if I could switch off the feature that returns column names, rather than having to delete it  once back in Excel.

    Any help appreciated.

    Rob

    Wednesday, February 14, 2007 4:38 PM