Making SQL Calls within Excel

M

Mark

How do you make SQL statement calls to a SQL Server
database from within Excel? Can they be made as part of a
cell formula and recalculated periodically?
 
J

Jan Karel Pieterse

Hi,

Check out Data, Get External data from within Excel.

Regards,

Jan Karel Pieterse
Excel TA/MVP
 

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

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Place picture in Excel cell 0
Need Help with Macro Security 1
Word macro that can call cells out of Excel for a find and replace 0
Merging from an Excel file with graphics 1
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
how do I import data in excel form SQL server? 7
ODBC Error en Organigrama en Visio. 0

Top