New to SQL need some basic info

[atray04]

I am writing a VBA macro in Excel and I might eventually need to get the data from a SQL server. I have never used SQl so I was needing to know what to do once I have access to the server. Is there a place for me to go to get more information on this or are there some basic things you could tell me that would help get me started. I can give some details on exactly of what I want if that will help.

 

[nigelrivett]

To get data from sql server from vb script see

http://www.nigelrivett.net/DBAccess.inc.html

This is more complicated than you may need - just pick out the bits you need and put it in in-line code.
You should always access the data via stored procedures as this is more flexible, maintainable and secure.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[atray04]

That is great and will probably help me out, but I need a little background info on using sql in vba.

Now I have never seen a sql server before or worked with them. So I am confused on what to do.