Posts by Ceelly

    Re: Ues SQL on data in Active Workbook

    Thanks for your replys.. It would be nice if you could do this effectively with SQL in excel.. I ended up using a filter to create a new block of data from existing data in the workbook using VB code.


    Was wording if anyone knew of a way to run a SQL to create a new block of data from a pre-existing block of data in the current active workbook???

    I am very used to using SQL statements to extract data from databases into excel workbooks and would dearly love to use SQL to manipulate the data already in the current active workbook.

    Is this remotely possible or just a pipe dream???

    Thanking in advance