SQL-EXCEL VBA TUTORIAL

G

Guest

Is there anyone who could advise me on sql & excel vba tutorials ?

Most of tutorials I can find in the web don't focus enough in this subject...

TIA
 
T

Tim

Since most "code it yourself" (ie. not using "querytables") Excel/SQL VBA
involves using ADO, your biggest source of examples is likely to be found by
searching the web for examples of doing this from ASP (Active Server Pages)
using vbscript (which is close enough for an easy translation to VBA).

Tim
 
G

Guest

Thanks, Tim. I'll check that out. But I'm a T-SQL guy don't do Vbasic or
ADO......I suppose I'll have to learn.

sigh
 

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

The Basics 4
Fast intro to dictionary object in VBA/Excel 0
VBA Code to monitor standard toolbar buttons. 1
Excel VBA Programming 2
Calling Excel shortcuts from VBA 1
Excel + Query Tutorial Recommended? 1
Excel VBA in Citrix. 0
Scrolling down a web page using VBA 1

Top