1 2 3
| INSERT INTO transport ( Numéro, [date], batch, carrname, cash_mngt, clientno, dgl_report, consignee, consignor, dest_city, dest_cty, [exception], handling, iduty, impvat, toll_fee, fuel_schg, misc, insurance, inco_terms, inv_date, inv_type, mastinv_no, mode, org_city, org_cty, paid, paylogdate, proc_date, prodate, pronumber, rcwt, rec_date, rejkey, rel_date, seqnum, ship_date, trans, vat, vatperc, weight, dim_wt, account, account2, account3, account4, account5, account6, account7, account8, account9, po, serv_level, carracct )
SELECT transport.Numéro, Forms!Excel_File!txtdate AS Period, transport.batch, transport.carrname, transport.cash_mngt, transport.clientno, transport.dgl_report, transport.consignee, transport.consignor, transport.dest_city, transport.dest_cty, transport.exception, transport.handling, transport.iduty, transport.impvat, transport.toll_fee, transport.fuel_schg, transport.misc, transport.insurance, transport.inco_terms, transport.inv_date, transport.inv_type, transport.mastinv_no, transport.mode, transport.org_city, transport.org_cty, transport.paid, transport.paylogdate, transport.proc_date, transport.prodate, transport.pronumber, transport.rcwt, transport.rec_date, transport.rejkey, transport.rel_date, transport.seqnum, transport.ship_date, transport.trans, transport.vat, transport.vatperc, transport.weight, transport.dim_wt, transport.account, transport.account2, transport.account3, transport.account4, transport.account5, transport.account6, transport.account7, transport.account8, transport.account9, transport.po, transport.serv_level, transport.carracct
FROM transport; |
Partager