SQL-EXCEL VBA TUTORIAL
 

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

SQL-EXCEL VBA TUTORIAL
 

I am also looking for something like this. Anyone? Bueller? ......

"sharon" wrote:

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

SQL-EXCEL VBA TUTORIAL
 

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


"Johnslg" wrote in message
...
I am also looking for something like this. Anyone? Bueller? ......

"sharon" wrote:

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

SQL-EXCEL VBA TUTORIAL
 

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

"Tim" wrote:

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


"Johnslg" wrote in message
...
I am also looking for something like this. Anyone? Bueller? ......

"sharon" wrote:

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