VBA and Queries

[Shaun]

Hi All

Does anyone know of any resources which can teach me about preparing DB queries in excel using VBA? I have no idea and recording Microsoft Query macros will get me so far.

I have looked around, but most of the stuff I have found assumes I know more than I do. I need to start at the bottom.

Cheers

 

[NARAYANK991]

Hi Shaun ,

Since you say you are a beginner , you might find this useful :

http://analystcave.com/excel-tools/excel-sql-add-in-free/

For an introduction to SQL , see this :

http://www.baldyweb.com/buildsql.htm

Narayan

 

[Shaun]

Hi Narayan

Thank you for the links. If you know of anymore please let me know.

Cheers

 

[NARAYANK991]

Hi Shaun ,

1. http://analysistabs.com/excel-vba/ado-sql-macros-connecting-database/

2. http://excel-macro.tutorialhorizon.com/vba-excel-read-excel-workbook-as-database-using-odbc-source/

3. http://itknowledgeexchange.techtarget.com/beyond-excel/page/10/

The last named link is a treasure-house ; start at page 10 , and work your way to page 1.

Narayan

 

[Shaun]

Hi Narayan

Thank you for the additional links. That last link is a treasure house.

Thank you.

Shaun