Need Excel 2007 VBA Macro for ODBC Connection

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.

For instance...

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.

Evner: Dataindførsel, Excel, Visual Basic

Se mere: excel 2007 odbc data connection vba, macro odbc excel 2007, odbc connect string excel macro 2007 windows, odbc connect string excel macro 2007, excel 2007 vba odbc connection string, odbc excel vba, data connection odbc excel macro vba, excel 2007 odbc connection macro, excel out source, excel macro how to, data entry macro, data entry in excel 2007, vba excel 2007 odbc, me vba, vba excel macro, excel vba macro, excel to vba, Excel Macro VBA, Excel and VBA, excel database visual basic

Om arbejdsgiveren:
( 12 bedømmelser ) Riverview, United States

Projekt ID: #4078403

Tildelt til:


I'm ready as soon as you are.

$30 USD på 1 dag
(7 bedømmelser)