ProductsTechnical SupportDownloadsPurchasingSearch EngineNewsHomeE-mail Us

With Excel or any VBA application it is possible to use the OLE type library. In VBA, select the reference to the Data Control Type library. To create this, use the option ‘Tools/Reference’ and then select ‘ACE/400 DAO’.
Then, you will be able to make source code like this:

Dim db As Database
Set rs = db.OpenRecordSet(FileName, dbReadOnly)
rs.MoveFirst
While Not rs.EOF
' set starting column
c = 2
' get record field values
For Each Field In rs.Fields
Cells(r, c) = Field
c = c + 1
Next Field
' read the next record
rs.MoveNext
r = r + 1
Wend


With Microsoft VBA you will be able to use the Object Browser as in VB.

Back Visual Basic VBScript Powerbuilder Visual C++