BEST PRACTICES -> SQL with DAO

[Irish_Griffin]

Hi guys,
I've discovered excel can do SQL !!! It feels like I'm the primitive caveman discovering fire

Well lets not talk about how much time I've wasted writing code that would have been soooooooo much easier in SQL .... Instead, lets talk about BEST PRACTICES using SQL in EXCEL

I would like to make this thread a good reference for others ( not much online surprisingly ). I'll make this a sweet thread if I can get the guru's help.

So first and foremost:
#1 - Is DAO the right choice ?

Remember to take learning one bite at a time:

 

[termeric]

since my query is essentially a SQL statement, could i just use that?

 

[Irish_Griffin]

since my query is essentially a SQL statement, could i just use that?

Hi,
I don't quite understand the Question.

I have been using Microsoft Acces to Query builder then selecting Veiw-> SQL Code

I find this to be a great way to learn and generate the code you need. ( although expect to remove some un-needed code the acces puts in ( extra parentheses and what not )

 

[Irish_Griffin]

Hi Everyone.

I wanted to post up the entire tool for anyone use.

Everything it it is pretty well noted. I have found it to be a excellent starting point when trying to create any excel tool that deals with large data comparing, filtering and calculating.

Depending on what you are doing; a first step would be creating a function that outputs the ADO connection string so that it is in one location.

If your a guru, please consider creating a new revision of the tool and posting it up.


http://www.sendspace.com/file/58c7t6


THANKS FOR ALL THE HELP!!
- Griff

 

[SamTYler]

Blade,

Consider an Index Table where each RS consists of all the misspellings paired with the correct spelling, (or other unique identifier.)

While this is WAaayy out of my depth, I do know that it is a charactistic of well designed databases.

<PRE>
Primary Key               Secondary Key
Thriller                       Thriller
Thriler                        Thriller
Thrillerr                      Thriller
</PRE>