Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
Back to article list Search Articles Add Comment Printer friendly Direct link Par2: Reading Excel files with ODBC (DSNless connection) 2009-07-01 -- J Shankar As posted by somebody on the NG ::
LOC:NAME STRING('[SHEET1$]')
LOC:FILENAME STRING('SOMEFILE.XLS')
LOC:PATH STRING('C:\SOMEPATH')
LOC:OWNER STRING(300)
EXCEL FILE,DRIVER('ODBC','/VERIFYVIASELECT =
TRUE'),PRE(EXC),BINDABLE,CREATE,THREAD,NAME(LOC:NAME),OWNER(LOC:OWNER)
Record RECORD,PRE()
NOMBRE1 STRING(15)
NOMBRE2 STRING(15)
APATERNO STRING(20)
......
LOC:OWNER = 'Driver={{Microsoft Excel Driver (*.xls)};DriverId=790;'& |
'Dbq='&CLIP(LOC:FILENAME)&';DefaultDir='&CLIP(LOC:PATH)
OPEN(EXCEL)
SET(EXCEL)
LOOP
NEXT(EXCEL)
IF ERRORCODE() THEN BREAK.
.....
Today is May 4, 2024, 9:01 am This article has been viewed 35119 times.
|
|