I have an ODBC connection created in windows 7. I just need the snippet of code that allows me to connect to the data source and pull out individual records (no table headings, no formating). I'm using excel 2007.
I want to run this loop:
while not empty(activecell)
activecell = "SELECT (field1) FROM `(database)`.`(table)` where (field2)=c&x)"
Something like that..
I don't know how to make the valid connection string, so this is possible. That string is all I need, I think so I can start making the loop work.