Example no.3 - tens (or thousands) steps in one script. Many libraries used. 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. Start: [F5] or [Ctrl+Q]
e.g. Path = C:\AnyPath      
e.g. Database =        
e.g. Period =        
()        
         
         
Class (Vendor) Object Command Parameters Info The rest: Comments, calculations, row parameters
AFinScriptStart       0,004
# This example is almost "professional". You have much of data in many separated files. You can consolidate them in one process UNDER YOUR FULL CONTROL. This is closed to professional data process making a data warehouse - your own data warehouse. This example is runable. .
.       .
# You can delete the database file and download it again everytime OR(!) drop the table in existing file only .
Afin.Shell   del C:\AnyPath\MyDatabase.accdb   0,067
Afin.SQL C:\AnyPath\MyDatabase.accdb DROP TABLE MyDataTogether   .
# Erase the data and wait a while to end Shell processes .
Afin.Shell   del C:\AnyPath\Faktury*.xls   0,105
Afin.ScriptManager   Wait TimeSeconds=2 2,006
# Download an EMPTY database from Internet .
Afin.Internet http://afin.net/downloads/free/AfinSqlScript/TestAccessDB.accdb DOWNLOAD LocalFile=C:\AnyPath\MyDatabase.accdb 1,244
# Download data (3 separate Excel files) .
Afin.Internet http://afin.net/excel/soa/DaneDoCwiczenSOA/Faktury1.xls DOWNLOAD LocalFile=C:\AnyPath\Faktury1.xls 0,074 1
# The formula of the cell above:
="http://afin.net/excel/soa/DaneDoCwiczenSOA/Faktury"&F23&".xls"
  The formula of the cell above:
="LocalFile=C:\AnyPath\Faktury"&F23&".xls"
.
Afin.Internet http://afin.net/excel/soa/DaneDoCwiczenSOA/Faktury2.xls DOWNLOAD LocalFile=C:\AnyPath\Faktury2.xls 0,069 2
Afin.Internet http://afin.net/excel/soa/DaneDoCwiczenSOA/Faktury3.xls DOWNLOAD LocalFile=C:\AnyPath\Faktury3.xls 0,073 3
# In this way you can download (and than consolidate) hudreds of files - with ONE FORMULA and an index as line parameter.  
.       .
# Create an empty database table in an external database .
Afin.SQL C:\AnyPath\MyDatabase.accdb CREATE TABLE MyDataTogether(
SourceId VARCHAR(5),
CustomerName VARCHAR(20),
Sales DOUBLE)
  0,058
# Insert data from tables in defferent Excel files (index of file is in 'F' column) .
Afin.SQL C:\AnyPath\MyDatabase.accdb INSERT INTO MyDataTogether
SELECT '1' AS SourceId, Nazwa AS Name, wart_net AS Sales
FROM [faktura$]
IN 'C:\AnyPath\Faktury1.xls' [Excel 8.0;]
  0,078 1
#   The formula of the cell above:
="INSERT INTO MyDataTogether
SELECT '"&F32&"' AS SourceId, Nazwa AS Name, wart_net AS Sales
FROM [faktura$]
IN 'C:\AnyPath\Faktury"&F32&".xls' [Excel 8.0;]"
(The same parametrization rules) .
Afin.SQL C:\AnyPath\MyDatabase.accdb INSERT INTO MyDataTogether
SELECT '2' AS SourceId, Nazwa AS Name, wart_net AS Sales
FROM [faktura$]
IN 'C:\AnyPath\Faktury2.xls' [Excel 8.0;]
  0,078 2
Afin.SQL C:\AnyPath\MyDatabase.accdb INSERT INTO MyDataTogether
SELECT '3' AS SourceId, Nazwa AS Name, wart_net AS Sales
FROM [faktura$]
IN 'C:\AnyPath\Faktury3.xls' [Excel 8.0;]
  0,077 3
# Fill the sheet with data .
Afin.SQL C:\AnyPath\MyDatabase.accdb SELECT *
FROM MyDataTogether
PasteTo=ResultOfExampleNo3 0,071
00:04,1
Note: This process makes the data NOT IN THE MOST PROPER STATE. We intend to show a process, you can see this process in its full version in another example.