ClulessChris
IS-IT--Management
Can anybod give me some pointers on using Sql to search an Excel spreadsheet?
I'm familiar with using DAO / ADO to query a database, but in this instance I'd like to query a spreadsheet from within the same workbook (e.g. Sheet1!A1 = "SELECT 'column C' FROM Sheet2 WHERE 'Column B' = 123").
Is it even worth doing this with VB or are there inbuilt Functions for this action?
Everybody body is somebodys Nutter.
I'm familiar with using DAO / ADO to query a database, but in this instance I'd like to query a spreadsheet from within the same workbook (e.g. Sheet1!A1 = "SELECT 'column C' FROM Sheet2 WHERE 'Column B' = 123").
Is it even worth doing this with VB or are there inbuilt Functions for this action?
Everybody body is somebodys Nutter.