Macro - Run SQL in ODBC

Sub RunODBC()
'
' extract data from a database using ODBC the following parameters
'
' Conn - connection string to the ODBC database
' SQL - the SQL to be run
' Extract - where the extracted data is to be written
' Note that the sequence of parameters does not matter
'
Dim oEZ As New cEZ

oEZ.ODBC _
Conn:="c:\test\xlac\data\fa.mdb", _
SQL:="Select * from fixasset", _
Extract:=BASEDIR & "fa.txt"

LoadSheet _
ToSheet:="$Debug", _
Infile:=BASEDIR & "fa.txt"

Set oEZ = Nothing
End Sub

Main Page

Complete Auditor resources
Links \| Privacy Policy \| FAQ \| Downloads \| Trademarks