devxlogo

Answering SQL Queries in Excel

Answering SQL Queries in Excel

Question:
I’ve got an Excel workbook composed by a series of pages (worksheets). One of them is called ‘Wholesales’. I’ve tried to retrieve values even with basic syntax:

select * from Wholesales

but with no result. What is going on?

Answer:
Excel does not answer SQL queries like this. If you need access to the Wholesales sheet of your workbook, you need to create an object reference to the Excel application and retrieve your values from the object reference. Something like this:

loxx = CreateObject('ExcelApplication') 

or

loxx = new('excel')

Then interrogate the reference with words to the effect of “loxx.row.value”.

See also  How to Avoid Money Transfer Scams  
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist