Sedang Disiapkan

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:

x=1

range(A&x).select

while not empty(activecell)

range(b&x).select

activecell = "SELECT (field1) FROM `(database)`.`(table)` where (field2)=c&x)"

x=x+1

range(a&x).select

wend

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: macro odbc excel 2007, odbc excel vba, excel source, data entry macro, data entry excel 2007, vba excel 2007 odbc, me vba, vba excel macro, excel vba macro, excel macro vba, excel vba, excel database visual basic, think vba, windows vba, range macro excel, excel 2007 vba, odbc code, excel vba range table, loop table, excel connection, vba range table, loop excel visual basic, data vba, instance excel, macro excel database

Tentang Majikan:
( 12 ulasan ) Riverview, United States

ID Projek: #4078403

Dianugerahkan kepada:

weonlydo

I'm ready as soon as you are.

$30 USD dalam sehari
(7 Ulasan)
3.7