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.

Kemahiran: Pemasukan Data, Excel, Visual Basic

Lihat lebih lanjut: 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, think vba, windows vba, visual basic database excel database, range macro excel, excel 2007 vba

Tentang Majikan:
( 12 ulasan ) Riverview, United States

ID Projek: #4078403

Dianugerahkan kepada:


I'm ready as soon as you are.

$30 USD dalam sehari
(7 Ulasan)