recommendations for learning database calls in VBA

[jmckeone]

My company has a SQL database with an Access front end. Much of the data I deal with comes from there. Rather than relying on dumps which give me a lot of information I don't need and having to clean it up I'd like to be able to code my workbook to pull the needed data as it would be a huge time savings. Is there a sub-forum of the board specializing with this?

 

[Fazza]

Some of these might help? Or a good VBA for Excel book.

http://www.w3schools.com/sql/default.asp
http://www.sqlzoo.net/
http://www.bygsoftware.com/Excel/sql.htm
http://www.erlandsendata.no/
http://www.dicks-clicks.com/excel/ExternalData5.htm#ChangeSQL
http://www.ozgrid.com/forum/forumdisplay.php?f=31
http://www.xtremevbtalk.com/showthread.php?t=217783
http://excelkb.com/

 

[Richard Schollar]

Excel Advanced Report Development by Tim Zapawa is well worth a look.