Afin.Query   AfinScript AFIN 2016
  Start: [F5] or [Ctrl+Q]
<<< Parameters   Info: 5 columns (A:E = 'COCPI..T') from the #11 row are reserved for the AfinScript's program.
e.g. Path = C:\AnyPath      
e.g. Database =        
e.g. Period =        
()        
         
         
Class (Vendor) Object Command Parameters Info The rest: Comments, calculations, row parameters
Afin.Query commands       .
.       .
Afin.Query   Info   OK, but it stops the program.
Afin.Query ODBC;DSN=Excel files; DBQ=C:\AnyPath\Testy\Sprzedaz2015_testy.xlsx SELECT COUNT(*) AS [MyCount]
FROM [Faktura$]
PasteTo=Query; Name=MyQuery .
Afin.Query C:\AnyPath\Testy\Sprzedaz2015_testy.xlsx SELECT COUNT(*) AS [MyCount]
FROM [Faktura$]
PasteTo=Query; Name=MyQuery . If standard MS Query prefix like 'ODBC;DSN=Excel files; DBQ=' is omitted, it is filled in automatically (for popular file databases only)
Afin.Query URL;http://nbp.pl   PasteTo=WebQuery; Name=NBP .
Afin.Query URL;http://carbon.brighterplanet.com/flights.txt   PasteTo=MySheet1!K1; Name=NBP; PostText=origin_airport=WAW&destination_airport=JFK .