I gang

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.

Færdigheder: 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, think vba, windows vba, visual basic database excel database, range macro excel, excel 2007 vba

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

Projekt-ID: #4078403

Tildelt til:

weonlydo

I'm ready as soon as you are.

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