SQL statements in EXCEL

O

ontheDB

I'm populating a table from a SQL Server source.

I dump the info into a worksheet.
Is there anyway to query that info like it was still a database table
?
i.e. have SQL statements as the function of individual cells ?

Can functions be that complicated ?


also:
how do you supress the column titles when querying in SQL ?
 
A

Andy Wiggins

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/UsingSqlRequest.zip
It's in the "Excel with Access Databases" section on page:
http://www.bygsoftware.com/examples/examples.htm

This workbook demonstrates how to get data direct from an MS Access table,
or from an open or closed MS Excel workbook using the workbook function
SQL.REQUEST.

Recently updated to show the use of SQL.REQUEST in the same workbook.

The code is open and commented.


--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HELP: SQL in Excel VBA 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
SQL ODBC Connection 1
Slow running SQL via ADO connection in excel 2
SQL not importing records from ACCDB 2
Using a worksheet as a table in an SQL query 5
Excel as front end and SQL Server as back end 0
VBA Excel data to SQL Sever table 1

Top