1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| SQL Connect ...
T1:
LOAD z1,z2,z3;
SQL SELECT z1,z2,z3 from ...;
Store T1 into c:\qvdt1.qvd (QVD);
Drop table T1;
T2:
LOAD x1 as z1,x2,x3;
SQL SELECT x1,x2,x3 from ...;
Store T2 into c:\qvdt2.qvd (QVD);
Drop table T2;
T3:
LOAD y1 as z1,y2,y3;
SQL SELECT y1,y2,y3 from ...;
Store T3 into c:\qvdt3.qvd (QVD);
Drop table T3;
T4:
LOAD b1 as z1,b2,b3;
SQL SELECT b1,b2,b3 from ...;
Store T4 into c:\qvdt4.qvd (QVD);
Drop table T4;
T5:
LOAD e1,e2 from fichier.xlsx (ooxml, embedded labels, table is Feuille1);
Store T5 into c:\qvdt5.qvd (QVD);
Dropt table T5; |
Partager