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
| Data:
LOAD
recno() as Row,
Agence AS AGENCE.Agence,
Semaine AS AGENCE.Semaine,
[Nom TT] AS [AGENCE.Nom TT],
[Prénom TT] AS [AGENCE.Prénom TT],
[Nombre d'heures] AS [AGENCE.Nombre d'heures],
[Montant facturé] AS [AGENCE.Montant facturé]
FROM
[C:\Users\Nicolas\Desktop\QV\FICHIER AGENCE.xls]
(biff, embedded labels, table is Feuil1$);
Concatenate(Data)
LOAD
recno() as Row,
Agence AS EFLEX.Agence,
Semaine AS EFLEX.Semaine,
[Nom TT] AS [EFLEX.Nom TT],
[Prénom TT] AS [EFLEX.Prénom TT],
[Nombre d'heures] AS [EFLEX.Nombre d'heures],
[Montant facturé] AS [EFLEX.Montant facturé]
FROM
[C:\Users\Nicolas\Desktop\QV\FICHIER EFLEX.xls]
(biff, embedded labels, table is Feuil1$); |
Partager