For a tab delimited file, first you have to copy the physical file to a stream file in the document library. Notice no STMFCODPAG(*PCASCII).
CPYTOIMPF
FROMFILE(BRANDNEW/CARCODE)
TOSTMF('QIBM/CARCODE')
RCDDLM(*CRLF)
DTAFMT(*DLM)
STRDLM('"')
FLDDLM(X'05')
DECPNT(*PERIOD)
MBROPT(*ADD)...
I use Windows open file dialog API, instead of the file open dialog Extra has available.
The following code should be saved as a Header File:
File Open Header.ebh
============================================================
Type OPENFILENAME
lStructSize As Long
hwndOwner As Long...
Here is an example of creating/updating excel worksheet, range, whatever via ADO run w/Attachmate EXTRA! 7.0 Object Library & Microsoft DAO 3.6 Object Library.
Sub Main
Dim adoConn as object
Dim TableRS as object
Dim FieldRS As Object
Dim strConString as string
Dim FileName...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.