Python Forum
Python Forum

Connect old access datbase .mdb
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Connect old access datbase .mdb
Larz60+
aetate et sapientia
Super Moderators
Posts: 11,869
Threads: 473
Joined: Sep 2016
Reputation: 452
#11
Dec-15-2020, 11:44 AM
Here's the database schema:
schema:
I used python tags here so that window would scroll

mdb-schema dati.mdb
-- ----------------------------------------------------------
-- MDB Tools - A library for reading MS Access database files
-- Copyright (C) 2000-2011 Brian Bruns and others.
-- Files in libmdb are licensed under LGPL and the utilities under
-- the GPL, see COPYING.LIB and COPYING files respectively.
-- Check out http://mdbtools.sourceforge.net
-- ----------------------------------------------------------

-- That file uses encoding UTF-8

CREATE TABLE [Cartecredito]
 (
	[codice]			Integer, 
	[descrizione]			Text (50), 
	[percentuale]			Single, 
	[fisso]			Single
);

CREATE TABLE [certificati]
 (
	[numero]			Text (200), 
	[codice]			Text (200), 
	[oggetto]			Text (200), 
	[titolooro]			Text (200), 
	[peso]			Text (200), 
	[data]			Text (200), 
	[cliente]			Text (200), 
	[descrizione]			Memo/Hyperlink (255), 
	[controllo]			Memo/Hyperlink (255), 
	[totpietre]			Integer, 
	[varieta1]			Text (100), 
	[varieta2]			Text (100), 
	[varieta3]			Text (100), 
	[varieta4]			Text (100), 
	[varieta5]			Text (100), 
	[varieta6]			Text (100), 
	[peso1]			Text (100), 
	[peso2]			Text (100), 
	[peso3]			Text (100), 
	[peso4]			Text (100), 
	[peso5]			Text (100), 
	[peso6]			Text (100), 
	[colore1]			Text (100), 
	[colore2]			Text (100), 
	[colore3]			Text (100), 
	[colore4]			Text (100), 
	[colore5]			Text (100), 
	[colore6]			Text (100), 
	[purezza1]			Text (100), 
	[purezza2]			Text (100), 
	[purezza3]			Text (100), 
	[purezza4]			Text (100), 
	[purezza5]			Text (100), 
	[purezza6]			Text (100), 
	[dimensioni1]			Text (100), 
	[dimensioni2]			Text (100), 
	[dimensioni3]			Text (100), 
	[dimensioni4]			Text (100), 
	[dimensioni5]			Text (100), 
	[dimensioni6]			Text (100), 
	[taglioforma1]			Text (100), 
	[taglioforma2]			Text (100), 
	[taglioforma3]			Text (100), 
	[taglioforma4]			Text (100), 
	[taglioforma5]			Text (100), 
	[taglioforma6]			Text (100), 
	[valore]			Text (200)
);

CREATE TABLE [fattddt]
 (
	[tipo]			Integer, 
	[nfatt]			Text (10), 
	[data]			Text (12), 
	[r2]			Text (50), 
	[r3]			Text (50), 
	[paga]			Text (44), 
	[corpo]			Text (100), 
	[iva]			Integer, 
	[riga]			Integer, 
	[totale]			Single, 
	[r1]			Text (60), 
	[note]			Text (70), 
	[r4]			Text (50), 
	[ragsoc2]			Text (50), 
	[accomp]			Text (2), 
	[documento]			Text (50), 
	[commento]			Text (100), 
	[scontrino]			Text (10), 
	[datascontrino]			Text (10), 
	[spunta]			Text (3), 
	[corpo2]			Text (100), 
	[r1sped]			Text (60), 
	[ragsoc2sped]			Text (50), 
	[r2sped]			Text (50), 
	[r3sped]			Text (50), 
	[r4sped]			Text (50), 
	[note2]			Text (70), 
	[udm]			Text (10), 
	[dataord]			Long Integer, 
	[calce1]			Text (70), 
	[calce2]			Text (70), 
	[calce3]			Text (70), 
	[calce4]			Text (70), 
	[ddtInFattura]			Text (250), 
	[codcli]			Long Integer, 
	[nomeFE]			Text (150), 
	[cognomeFE]			Text (150), 
	[naturaFE]			Text (250)
);

CREATE TABLE [GarCalce]
 (
	[testo]			Memo/Hyperlink (255)
);

CREATE TABLE [GarRipaCalce]
 (
	[testo]			Memo/Hyperlink (255)
);

CREATE TABLE [immagini]
 (
	[codice]			Long Integer, 
	[percorso]			Text (150)
);

CREATE TABLE [magqta]
 (
	[codice]			Long Integer, 
	[qta]			Long Integer
);

CREATE TABLE [negozio]
 (
	[corrente]			Long Integer
);

CREATE TABLE [noteagg]
 (
	[codice]			Long Integer, 
	[gr]			Single, 
	[kt1]			Single, 
	[kt2]			Single
);

CREATE TABLE [tabacc]
 (
	[codice]			Long Integer, 
	[data]			Text (10), 
	[acconto]			Single
);

CREATE TABLE [TabAcc2]
 (
	[codice]			Long Integer, 
	[data]			Text (10), 
	[acconto]			Single, 
	[cliente]			Text (50)
);

CREATE TABLE [TabCategorie]
 (
	[cod]			Integer, 
	[descr]			Text (50)
);

CREATE TABLE [TabCatSpese1]
 (
	[cod]			Integer, 
	[descr]			Text (40)
);

CREATE TABLE [TabCatSpese2]
 (
	[codp]			Integer, 
	[cod]			Integer, 
	[descr]			Text (40)
);

CREATE TABLE [TabCespiti]
 (
	[descr]			Text (50), 
	[anno]			Integer, 
	[valore]			Double, 
	[perc]			Integer
);

CREATE TABLE [tabcosto]
 (
	[cifra]			Integer, 
	[lettera]			Text (1)
);

CREATE TABLE [TabCstorico]
 (
	[codice]			Text (8), 
	[prezzoco]			Long Integer
);

CREATE TABLE [tabcv]
 (
	[codice]			Long Integer, 
	[cliente]			Text (50), 
	[datafinev]			Text (10), 
	[datauscita]			Text (10), 
	[acconto]			Single, 
	[prvend]			Single
);

CREATE TABLE [TabDettTrasporto]
 (
	[tipo]			Long Integer, 
	[numdoc]			Text (10), 
	[causale]			Text (50), 
	[porto]			Text (50), 
	[trasportomezzo]			Text (50), 
	[vettore]			Text (50), 
	[peso]			Text (50), 
	[colli]			Text (50), 
	[data_ora]			Text (50)
);

CREATE TABLE [tabgio]
 (
	[peso]			Single, 
	[costog]			Single, 
	[manif]			Single, 
	[incrodia]			Single, 
	[t1]			Single, 
	[t2]			Single, 
	[t3]			Single, 
	[t4]			Single, 
	[t5]			Single, 
	[t6]			Single, 
	[t7]			Single, 
	[t8]			Single, 
	[t9]			Single, 
	[t10]			Single, 
	[codice]			Text (10), 
	[note]			Text (250), 
	[nserie]			Text (80), 
	[vetro]			Text (80), 
	[misura]			Text (80), 
	[cassa]			Text (80), 
	[quadrante]			Text (80), 
	[certificato]			Text (80), 
	[bracciale]			Text (80), 
	[movimento]			Text (80), 
	[gemme]			Text (80), 
	[calibro]			Text (80), 
	[sottomodello]			Text (80), 
	[pietra1]			Text (80), 
	[pietra2]			Text (80), 
	[pietra3]			Text (80), 
	[forni1]			Text (80), 
	[forni2]			Text (80), 
	[forni3]			Text (80), 
	[fattura1]			Text (80), 
	[fattura2]			Text (80), 
	[fattura3]			Text (80), 
	[t11]			Single, 
	[t12]			Single, 
	[t13]			Single, 
	[t14]			Single, 
	[t15]			Single, 
	[t16]			Single
);

CREATE TABLE [tabinv]
 (
	[codice]			Long Integer, 
	[qta]			Long Integer
);

CREATE TABLE [TabIVA]
 (
	[anno]			Integer, 
	[mese]			Integer, 
	[valore]			Single
);

CREATE TABLE [TabLavRipa]
 (
	[cod]			Integer, 
	[descr]			Text (50), 
	[prpub]			Single, 
	[prcosto]			Single
);

CREATE TABLE [tablic]
 (
	[ragsoc]			Text (50), 
	[Ind]			Text (50), 
	[citta]			Text (50), 
	[cap]			Text (5), 
	[prov]			Text (2), 
	[piva]			Text (11), 
	[tel]			Text (30), 
	[fax]			Text (30), 
	[email]			Text (50), 
	[iva]			Integer, 
	[lecu]			Single, 
	[calo]			Long Integer, 
	[calo2]			Long Integer, 
	[arr]			Long Integer, 
	[stringaeti]			Text (50), 
	[arreuro]			Single, 
	[cf]			Text (16), 
	[Rea]			Text (30), 
	[CapSoc]			Text (30), 
	[ufficioRea]			Text (2), 
	[socioUnicoP]			Text (200), 
	[statoLiquidazione]			Text (200), 
	[regimeFiscaleP]			Text (200), 
	[esigibilitaIVA]			Text (200), 
	[progressivoFE]			Text (15), 
	[numOAM]			Text (50)
);

CREATE TABLE [tabliv]
 (
	[operatore]			Text (25), 
	[pass]			Text (25), 
	[livelli]			Text (15), 
	[clienti]			Integer, 
	[fornitori]			Integer, 
	[sms]			Integer
);

CREATE TABLE [TabLogEventi]
 (
	[tipoop]			Text (30), 
	[codice]			Text (8), 
	[oldprpub]			Single, 
	[newprpub]			Single, 
	[data]			Long Integer, 
	[ora]			Text (5)
);

CREATE TABLE [tabmag]
 (
	[codice]			Long Integer, 
	[codbar]			Text (8), 
	[descr]			Text (50), 
	[modello]			Text (50), 
	[forni]			Text (50), 
	[nfattura]			Text (50), 
	[punit]			Single, 
	[manif]			Text (50), 
	[cmetallo]			Long Integer, 
	[calo]			Long Integer, 
	[ricarico]			Text (50), 
	[datacarico]			Text (10), 
	[tipo]			Integer, 
	[prezzopu]			Long Integer, 
	[sconto]			Single, 
	[prezzoco]			Long Integer, 
	[sconto2]			Single, 
	[iva]			Long Integer, 
	[stato]			Text (50), 
	[imposto]			Text (2), 
	[situa]			Text (5), 
	[note]			Text (70), 
	[prezzopueuro]			Single, 
	[settore]			Integer, 
	[pos]			Integer, 
	[referenza]			Text (100), 
	[misura]			Text (30), 
	[completa]			Memo/Hyperlink (255)
);

CREATE TABLE [tabmet]
 (
	[oro]			Long Integer, 
	[argento]			Long Integer
);

CREATE TABLE [TabModifica]
 (
	[codice]			Text (8), 
	[datamod]			DateTime
);

CREATE TABLE [TabModPag]
 (
	[cod]			Integer, 
	[descr]			Text (50)
);

CREATE TABLE [tabogg]
 (
	[descrizione]			Text (25), 
	[escludi]			Integer
);

CREATE TABLE [TabPercSconti]
 (
	[inizio]			Text (4), 
	[fine]			Text (4), 
	[sconto]			Integer
);

CREATE TABLE [TabPos]
 (
	[cod]			Integer, 
	[descr]			Text (50)
);

CREATE TABLE [TabReferenze]
 (
	[referenza]			Text (100), 
	[sottoscorta]			Integer, 
	[continuativo]			Text (2)
);

CREATE TABLE [TabRFID]
 (
	[rfid]			Text (200), 
	[codice]			Text (8)
);

CREATE TABLE [tabric]
 (
	[codice]			Text (3), 
	[valore]			Long Integer
);

CREATE TABLE [TabRientri]
 (
	[codbar]			Text (8), 
	[descr]			Text (50), 
	[forni]			Text (50), 
	[prezzopu]			Single, 
	[prezzoco]			Single, 
	[prezzovend]			Single, 
	[datacarico]			Text (10), 
	[datascarico]			Text (10), 
	[datareso]			Text (10), 
	[dataord]			Long Integer, 
	[Esportato]			Text (20), 
	[situa]			Text (20)
);

CREATE TABLE [TabRipaOgg]
 (
	[descr]			Text (70)
);

CREATE TABLE [TabRitiroMetallo]
 (
	[numero]			Long Integer, 
	[cliente]			Text (100), 
	[data]			Text (10), 
	[dataord]			Long Integer, 
	[peso]			Single, 
	[valore]			Single, 
	[destinazione]			Text (40), 
	[operazione]			Integer, 
	[check1]			Text (2), 
	[check2]			Text (2), 
	[check3]			Text (2), 
	[check4]			Text (2), 
	[check5]			Text (2), 
	[check6]			Text (2), 
	[check7]			Text (2), 
	[osservazioni]			Text (100), 
	[descrizione]			Memo/Hyperlink (255), 
	[nato]			Text (100), 
	[indirizzo]			Text (100), 
	[documento]			Text (100), 
	[citta]			Text (100), 
	[rilasciodoc]			Text (100), 
	[codfiscale]			Text (100), 
	[datarilasciodoc]			Text (100), 
	[ora]			Text (5)
);

CREATE TABLE [tabsca]
 (
	[nfatt]			Text (50), 
	[forni]			Text (50), 
	[fino]			Long Integer, 
	[importo]			Single, 
	[tipomoneta]			Text (50), 
	[datafat]			Text (10), 
	[iva]			Long Integer, 
	[note]			Text (50), 
	[nrate]			Long Integer, 
	[tipopag]			Text (50), 
	[tiporeg]			Text (50), 
	[nrata]			Long Integer, 
	[valore]			Single, 
	[scadenza]			Text (10), 
	[orddata]			Long Integer, 
	[pagata]			Text (50), 
	[avviso]			Text (1), 
	[modpag]			Integer, 
	[noteRata]			Text (100)
);

CREATE TABLE [TabSconti]
 (
	[data]			Text (10), 
	[ordine]			Long Integer, 
	[valore]			Single, 
	[tessera]			Text (30), 
	[tipo]			Text (1)
);

CREATE TABLE [TabSetRipa]
 (
	[cod]			Integer, 
	[descr]			Text (50)
);

CREATE TABLE [TabSMS]
 (
	[numero]			Text (25), 
	[testo]			Text (255), 
	[data]			Long Integer, 
	[nome]			Text (100)
);

CREATE TABLE [TabSpese]
 (
	[codp]			Integer, 
	[cod]			Integer, 
	[descr]			Text (50), 
	[data]			Text (10), 
	[orddata]			Long Integer, 
	[tipo]			Integer, 
	[importo]			Double
);

CREATE TABLE [TabTessere]
 (
	[codbar]			Text (30), 
	[codice]			Long Integer
);

CREATE TABLE [tabven]
 (
	[codice]			Long Integer, 
	[codbar]			Text (8), 
	[descr]			Text (50), 
	[modello]			Text (50), 
	[forni]			Text (50), 
	[nfattura]			Text (50), 
	[datacarico]			Text (10), 
	[datascarico]			Text (10), 
	[tipo]			Integer, 
	[prezzopu]			Long Integer, 
	[prezzoco]			Long Integer, 
	[iva]			Long Integer, 
	[prezzopu2]			Long Integer, 
	[lecu]			Single, 
	[prezzovend]			Long Integer, 
	[peso]			Single, 
	[manif]			Text (50), 
	[cmetallo]			Long Integer, 
	[calo]			Long Integer, 
	[ricarico]			Text (50), 
	[sconto]			Single, 
	[sconto2]			Single, 
	[stato]			Text (50), 
	[imposto]			Text (50), 
	[situa]			Text (50), 
	[note]			Text (70), 
	[ordcarico]			Long Integer, 
	[ordscarico]			Long Integer, 
	[settore]			Integer, 
	[commento]			Text (50), 
	[pos]			Integer, 
	[venditore]			Integer, 
	[codreg]			Long Integer, 
	[referenza]			Text (100), 
	[misura]			Text (30), 
	[completa]			Memo/Hyperlink (255)
);

CREATE TABLE [TabVenditori]
 (
	[cod]			Integer, 
	[descr]			Text (50), 
	[stato]			Text (30)
);

CREATE TABLE [TabVerificaDB]
 (
	[codice]			Text (8), 
	[qta]			Integer, 
	[archivi]			Text (255)
);

CREATE TABLE [Temp2SottoscortaXLS]
 (
	[Referenza]			Text (100), 
	[Giacenza]			Long Integer, 
	[Venduto]			Long Integer, 
	[Venduto_AnnoCorrente]			Long Integer, 
	[Venduto_AnnoPrecedente]			Long Integer, 
	[Venduto_30]			Long Integer, 
	[Venduto_60]			Long Integer, 
	[Venduto_90]			Long Integer, 
	[Venduto_180]			Long Integer, 
	[Reso]			Long Integer, 
	[Acquisti_AnnoCorrente]			Long Integer, 
	[Acquisti_AnnoPrecedente]			Long Integer, 
	[Sottoscorta]			Long Integer, 
	[giacenza31dic]			Long Integer, 
	[Val_Giacenza_Pub]			Single, 
	[Val_Giacenza_Costo]			Single, 
	[Val_Acquisti_Pub_AnnoCorrente]			Single, 
	[Val_Acquisti_Costo_AnnoCorrente]			Single, 
	[Val_Acquisti_Pub_AnnoPrecedente]			Single, 
	[Val_Acquisti_Costo_AnnoPrecedente]			Single, 
	[Margine]			Single
);

CREATE TABLE [TempAnalisiForniXLS]
 (
	[Fornitore]			Text (100), 
	[Partenza_PZ]			Long Integer, 
	[Partenza_Costo]			Long Integer, 
	[Acquisti_PZ]			Long Integer, 
	[Acquisti_Costo]			Long Integer, 
	[Vendite_PZ]			Long Integer, 
	[Vendite_Costo]			Long Integer, 
	[Rimanenze_PZ]			Long Integer, 
	[Rimanenze_Costo]			Long Integer, 
	[Margine_Perc]			Single, 
	[Margine_Valore]			Single
);

CREATE TABLE [TempCatOIRXLS]
 (
	[IdWeb]			Text (100), 
	[codiceEG]			Text (100), 
	[Referenza]			Text (100), 
	[Descrizione]			Text (100), 
	[Marca]			Text (100), 
	[PrPubblico]			Single, 
	[PrListino]			Single, 
	[PrAffiliati]			Single, 
	[statoWEB]			Text (100), 
	[statoEG]			Text (100)
);

CREATE TABLE [TempCLIXLS]
 (
	[Codice]			Integer, 
	[Nominativo]			Text (60), 
	[Indirizzo]			Text (70), 
	[CAP]			Text (5), 
	[Citta]			Text (25), 
	[TEL]			Text (25), 
	[TelUff]			Text (20), 
	[Cellulare]			Text (20), 
	[EMail]			Text (50), 
	[Note]			Text (40), 
	[Nascita]			Text (10), 
	[CodFiscale]			Text (16), 
	[nTessera]			Text (30), 
	[Credito]			Single, 
	[Descrizione]			Memo/Hyperlink (255), 
	[Anniversario]			Text (10)
);

CREATE TABLE [TempDaRiordinareCIPXLS]
 (
	[Referenza]			Text (100), 
	[Giacenza]			Long Integer, 
	[Sottoscorta]			Long Integer, 
	[DaRiordinare]			Long Integer, 
	[Continuativo]			Text (100), 
	[Descrizione]			Text (100), 
	[Fornitore]			Text (100), 
	[Peso]			Single, 
	[Modello]			Text (100), 
	[PrezzoAcquisto]			Single
);

CREATE TABLE [TempIncassiXLS]
 (
	[Tipo]			Text (20), 
	[Codice]			Text (20), 
	[Descrizione]			Text (50), 
	[Data]			DateTime, 
	[PrPub]			Single, 
	[Incasso]			Single, 
	[Note_Cliente]			Text (50), 
	[Categoria]			Text (50), 
	[Costo]			Single, 
	[Fornitore]			Text (100), 
	[Settore]			Text (50)
);

CREATE TABLE [TempINVEXLS]
 (
	[Codice]			Text (8), 
	[Descrizione]			Text (50), 
	[Modello]			Text (50), 
	[Note]			Text (50), 
	[Fornitore]			Text (50), 
	[DataCarico]			Text (10), 
	[PrezzoPub]			Single, 
	[Qta]			Integer, 
	[PrezzoCosto]			Single
);

CREATE TABLE [TempInvXLS]
 (
	[Codice]			Text (8), 
	[Descrizione]			Text (50), 
	[Fornitore]			Text (50), 
	[Prezzo]			Single, 
	[Stato]			Text (30), 
	[QtaMancante]			Integer, 
	[Settore]			Integer, 
	[pos]			Integer
);

CREATE TABLE [TempMAGXLS]
 (
	[Codice]			Text (8), 
	[Descrizione]			Text (50), 
	[Modello]			Text (50), 
	[Note]			Text (50), 
	[Fornitore]			Text (50), 
	[PrezzoCo]			Single, 
	[PrezzoPu]			Single, 
	[Categoria]			Integer, 
	[DataCarico]			DateTime, 
	[Settore]			Integer, 
	[Peso]			Single, 
	[pos]			Integer, 
	[Manif]			Single, 
	[CostoStorico]			Single, 
	[Misura]			Text (30)
);

CREATE TABLE [TempMovMagXLS]
 (
	[Data]			DateTime, 
	[Causale]			Text (100), 
	[Codice]			Text (100), 
	[Descrizione]			Text (100), 
	[Fornitore]			Text (100), 
	[Costo]			Single
);

CREATE TABLE [TempResiQta]
 (
	[codbar]			Text (8), 
	[datacarico]			Text (10), 
	[noqta]			Long Integer
);

CREATE TABLE [TempResoXLS]
 (
	[Codice]			Text (8), 
	[Descrizione]			Text (50), 
	[Modello]			Text (50), 
	[Note]			Text (50), 
	[Fornitore]			Text (50), 
	[Peso]			Single, 
	[DataCarico]			DateTime, 
	[DataReso]			DateTime, 
	[PrezzoCo]			Single, 
	[PrezzoPu]			Single, 
	[Categoria]			Integer, 
	[Settore]			Integer, 
	[Manif]			Single
);

CREATE TABLE [TempRipaXLS]
 (
	[Nbusta]			Long Integer, 
	[Cliente]			Text (50), 
	[Riparatore]			Text (50), 
	[DataReg]			DateTime, 
	[DataUscita]			DateTime, 
	[DataRientro]			DateTime, 
	[DataConsegna]			DateTime, 
	[Garanzia]			Text (2), 
	[PrezzoCo]			Single, 
	[PrezzoPub]			Single, 
	[Descrizione1]			Text (70), 
	[Descrizione2]			Memo/Hyperlink (255), 
	[Riparazione2]			Memo/Hyperlink (255), 
	[Riparazione1]			Text (114)
);

CREATE TABLE [TempRitiroMetalloXLS]
 (
	[Numero]			Long Integer, 
	[Data]			DateTime, 
	[Cliente]			Text (100), 
	[Peso]			Single, 
	[Valore]			Single, 
	[Destinazione]			Text (40)
);

CREATE TABLE [TempSottoscortaXLS]
 (
	[Referenza]			Text (100), 
	[Giacenza]			Long Integer, 
	[Venduto]			Long Integer, 
	[Reso]			Long Integer, 
	[Sottoscorta]			Long Integer, 
	[Venduto_AnnoCorrente]			Long Integer, 
	[Venduto_AnnoPrecedente]			Long Integer, 
	[Acquisti_AnnoCorrente]			Long Integer, 
	[Acquisti_AnnoPrecedente]			Long Integer, 
	[Val_Giacenza_Pub]			Single, 
	[Val_Giacenza_Costo]			Single, 
	[Val_Acquisti_AnnoCorrente]			Single, 
	[Val_Acquisti_AnnoPrecedente]			Single
);

CREATE TABLE [TempVALANNOXLS]
 (
	[Codice]			Text (8), 
	[Descrizione]			Text (50), 
	[Fornitore]			Text (50), 
	[PrezzoCo]			Single, 
	[DataCarico]			DateTime, 
	[PrezzoPub]			Single, 
	[Modello]			Text (50), 
	[Note]			Text (70), 
	[Categoria]			Integer, 
	[Settore]			Integer, 
	[Ubicazione]			Integer, 
	[Peso]			Single, 
	[NomeSettore]			Text (100)
);

CREATE TABLE [TempVarAcquistiCZXLS]
 (
	[Codice]			Text (8), 
	[Descrizione]			Text (50), 
	[Modello]			Text (50), 
	[Fornitore]			Text (50), 
	[oldCosto]			Single, 
	[newCosto]			Single, 
	[Categoria]			Text (30), 
	[Magazzino]			Text (30), 
	[DataVariazione]			DateTime
);

CREATE TABLE [TempVEN2XLS]
 (
	[Codice]			Text (8), 
	[Descrizione]			Text (50), 
	[Modello]			Text (50), 
	[Fornitore]			Text (50), 
	[DataScarico]			DateTime, 
	[Incasso]			Single, 
	[Venditore]			Text (70), 
	[Cliente]			Text (70), 
	[NumReg]			Text (12)
);

CREATE TABLE [TempVENXLS]
 (
	[Codice]			Text (8), 
	[Descrizione]			Text (50), 
	[Modello]			Text (50), 
	[Note]			Text (50), 
	[Fornitore]			Text (50), 
	[PrezzoCo]			Single, 
	[PrezzoPu]			Single, 
	[Incasso]			Single, 
	[Categoria]			Integer, 
	[DataCarico]			DateTime, 
	[Datascarico]			DateTime, 
	[Settore]			Integer, 
	[Peso]			Single, 
	[Manif]			Single, 
	[CostoStorico]			Single, 
	[Misura]			Text (30)
);

CREATE TABLE [tipipag]
 (
	[tipo]			Text (50)
);

CREATE TABLE [DettVenduto]
 (
	[codreg]			Long Integer, 
	[codcli]			Long Integer
);

CREATE TABLE [immaR]
 (
	[codice]			Long Integer, 
	[percorso]			Text (150)
);

CREATE TABLE [puntatori]
 (
	[numpunta]			Long Integer
);

CREATE TABLE [TabCarrelliOiR]
 (
	[id]			Text (30), 
	[idweb]			Text (30), 
	[codiceinterno]			Text (8), 
	[dataord]			Long Integer, 
	[valore]			Single, 
	[esito]			Text (30)
);

CREATE TABLE [tabcli]
 (
	[Codice]			Long Integer, 
	[Tel]			Text (25), 
	[cap]			Text (5), 
	[citta]			Text (25), 
	[credito]			Long Integer, 
	[nascita]			Text (10), 
	[codfiscale]			Text (16), 
	[teluff]			Text (20), 
	[cell]			Text (20), 
	[note]			Text (40), 
	[nome]			Text (60), 
	[tipo]			Integer, 
	[email]			Text (50), 
	[indirizzo]			Text (70), 
	[nome2]			Text (60), 
	[noteagg]			Memo/Hyperlink (255), 
	[documento]			Text (20), 
	[titolo]			Text (50), 
	[piva]			Text (13), 
	[nazione]			Text (60), 
	[datamano]			Text (10), 
	[pollicedx]			Text (10), 
	[pollicesx]			Text (10), 
	[indicedx]			Text (10), 
	[indicesx]			Text (10), 
	[mediodx]			Text (10), 
	[mediosx]			Text (10), 
	[anularedx]			Text (10), 
	[anularesx]			Text (10), 
	[mignolodx]			Text (10), 
	[mignolosx]			Text (10), 
	[iban]			Text (27), 
	[titolosped]			Text (50), 
	[nomesped]			Text (60), 
	[nome2sped]			Text (60), 
	[indirizzosped]			Text (70), 
	[capsped]			Text (5), 
	[cittasped]			Text (25), 
	[nazionesped]			Text (60), 
	[anniversario]			Text (10), 
	[rilasciodoc]			Text (100), 
	[datarilasciodoc]			Text (100), 
	[pec]			Text (100), 
	[provincia]			Text (2), 
	[codnazione]			Text (100), 
	[codiceDestinatario]			Text (7)
);

CREATE TABLE [tabforni]
 (
	[Codice]			Long Integer, 
	[Nome]			Text (30), 
	[cap]			Text (50), 
	[Note]			Text (50), 
	[sconto]			Single, 
	[sconto2]			Single, 
	[prov]			Text (2), 
	[stato]			Text (15), 
	[rif]			Text (30), 
	[noterif]			Text (30), 
	[telrif]			Text (30), 
	[codfiscale]			Text (16), 
	[selez]			Integer, 
	[ricar]			Integer, 
	[nome2]			Text (30), 
	[tel]			Text (30), 
	[email]			Text (50), 
	[brand]			Text (30), 
	[cat1]			Integer, 
	[cat2]			Integer, 
	[cat3]			Integer, 
	[cat4]			Integer, 
	[cat5]			Integer, 
	[cat6]			Integer, 
	[piva]			Text (13), 
	[iban]			Text (27), 
	[nomesped]			Text (30), 
	[nome2sped]			Text (30), 
	[capsped]			Text (50), 
	[provsped]			Text (2), 
	[statosped]			Text (15), 
	[indirizzo]			Text (70), 
	[citta]			Text (50), 
	[indirizzosped]			Text (70), 
	[cittasped]			Text (50)
);

CREATE TABLE [tablav]
 (
	[valore]			Long Integer, 
	[codice]			Text (5)
);

CREATE TABLE [TabLogUbi]
 (
	[codice]			Text (8), 
	[descrizione]			Text (30), 
	[data]			DateTime, 
	[sorg]			Integer, 
	[dest]			Integer
);

CREATE TABLE [TabMovCarteCredito]
 (
	[data]			Text (10), 
	[tot]			Single, 
	[codicecarta]			Integer, 
	[percentuale]			Single, 
	[netto]			Single, 
	[orddata]			Long Integer, 
	[fisso]			Single
);

CREATE TABLE [tabreso]
 (
	[codbar]			Text (50), 
	[Forni]			Text (50), 
	[Descr]			Text (50), 
	[Prezzoco]			Long Integer, 
	[Prezzocoeuro]			Long Integer, 
	[datacarico]			Text (10), 
	[datascarico]			Text (10), 
	[modello]			Text (50), 
	[tipo]			Long Integer, 
	[punit]			Single, 
	[codice]			Long Integer, 
	[nfattura]			Text (50), 
	[manif]			Text (50), 
	[cmetallo]			Long Integer, 
	[calo]			Long Integer, 
	[ricarico]			Text (50), 
	[prezzopu]			Long Integer, 
	[sconto]			Single, 
	[sconto2]			Single, 
	[iva]			Long Integer, 
	[stato]			Text (50), 
	[imposto]			Text (2), 
	[situa]			Text (5), 
	[note]			Text (70), 
	[prezzopueuro]			Single, 
	[settore]			Integer, 
	[ordcarico]			Long Integer, 
	[ordscarico]			Long Integer, 
	[pos]			Integer, 
	[referenza]			Text (100), 
	[misura]			Text (30), 
	[completa]			Memo/Hyperlink (255)
);

CREATE TABLE [tabripa]
 (
	[Nome]			Text (25), 
	[Tel]			Text (25), 
	[Nbusta]			Long Integer, 
	[data]			Text (10), 
	[Descrizione]			Text (30), 
	[costo]			Long Integer, 
	[vendita]			Long Integer, 
	[riparatore]			Text (50), 
	[consegnato]			Text (50), 
	[datacons]			Text (10), 
	[datauscita]			Text (50), 
	[datarientro]			Text (50), 
	[posizione]			Text (50), 
	[dataprev]			Text (10), 
	[assicurato]			Long Integer, 
	[note]			Text (30), 
	[settore]			Integer, 
	[utente]			Text (25), 
	[cell]			Text (20), 
	[prevt]			Text (12), 
	[prev]			Long Integer, 
	[garanzia]			Long Integer, 
	[opeseguite]			Text (120), 
	[codcli]			Long Integer, 
	[valdichiarato]			Text (50), 
	[acconto]			Text (50), 
	[pesopietre]			Text (50), 
	[descr2]			Memo/Hyperlink (255), 
	[oper2]			Memo/Hyperlink (255), 
	[pronta]			Boolean NOT NULL, 
	[venditore]			Integer, 
	[smsSent]			Boolean NOT NULL, 
	[lavorazioni]			Text (250), 
	[noteinterne]			Memo/Hyperlink (255), 
	[dPreventivo]			Integer, 
	[email]			Text (50), 
	[operazioni]			Text (114), 
	[pos]			Integer
);

CREATE TABLE [TabRipaUbi]
 (
	[numerazione]			Text (10), 
	[ubicazione]			Integer
);

CREATE TABLE [TabSettori]
 (
	[cod]			Integer, 
	[descr]			Text (50)
);

CREATE TABLE [TabUltimi]
 (
	[Tipo]			Integer, 
	[Valore]			Text (10)
);

CREATE TABLE [TempAcquistiCZXLS]
 (
	[Fornitore]			Text (50), 
	[NumFattura]			Text (50), 
	[Categoria]			Integer, 
	[NumPezzi]			Long Integer, 
	[Costo]			Single, 
	[Stato]			Text (30), 
	[Magazzino]			Text (30), 
	[DataFattura]			DateTime
);

CREATE TABLE [TempDaRiordinareXLS]
 (
	[Referenza]			Text (100), 
	[Giacenza]			Long Integer, 
	[Sottoscorta]			Long Integer, 
	[DaRiordinare]			Long Integer, 
	[Continuativo]			Text (100)
);

CREATE TABLE [TempMultidbCZXLS]
 (
	[Codice]			Text (8), 
	[Descrizione]			Text (50), 
	[Modello]			Text (50), 
	[Fornitore]			Text (50), 
	[Pubblico]			Single, 
	[Costo]			Single, 
	[Stato]			Text (30), 
	[Magazzino]			Text (30)
);

CREATE TABLE [TempScadenXLS]
 (
	[nFattura]			Text (50), 
	[nRata]			Integer, 
	[Fornitore]			Text (50), 
	[TipoPagamento]			Text (50), 
	[Scadenza]			DateTime, 
	[Importo]			Single, 
	[Note]			Text (80), 
	[PAGATA]			Text (10), 
	[PagamentoRata]			Text (100), 
	[NoteRata]			Text (100)
);
Find
Reply
nio74maz
Silly Frenchman
Posts: 30
Threads: 11
Joined: Dec 2020
Reputation: 0
#12
Dec-15-2020, 06:16 PM
You are the best, but I must to do it work in windows 10 Wall Wall
Find
Reply
Larz60+
aetate et sapientia
Super Moderators
Posts: 11,869
Threads: 473
Joined: Sep 2016
Reputation: 452
#13
Dec-15-2020, 06:58 PM (This post was last modified: Dec-15-2020, 07:00 PM by Larz60+.)
see last line of post 10
https://python-forum.io/Thread-Connect-o...#pid133160

you can use following commands to export tables. I tried it and it works
Output:
mdb-export dati.mdb Cartecredito > Cartecredito.csv
mdb-export dati.mdb certificati > certificati.csv
mdb-export dati.mdb fattddt > fattddt.csv
mdb-export dati.mdb GarCalce > GarCalce.csv
mdb-export dati.mdb GarRipaCalce > GarRipaCalce.csv
mdb-export dati.mdb immagini > immagini.csv
mdb-export dati.mdb magqta > magqta.csv
mdb-export dati.mdb negozio > negozio.csv
mdb-export dati.mdb noteagg > noteagg.csv
mdb-export dati.mdb tabacc > tabacc.csv
mdb-export dati.mdb TabAcc2 > TabAcc2.csv
mdb-export dati.mdb TabCategorie > TabCategorie.csv
mdb-export dati.mdb TabCatSpese1 > TabCatSpese1.csv
mdb-export dati.mdb TabCatSpese2 > TabCatSpese2.csv
mdb-export dati.mdb TabCespiti > TabCespiti.csv
mdb-export dati.mdb tabcosto > tabcosto.csv
mdb-export dati.mdb TabCstorico > TabCstorico.csv
mdb-export dati.mdb tabcv > tabcv.csv
mdb-export dati.mdb TabDettTrasporto > TabDettTrasporto.csv
mdb-export dati.mdb tabgio > tabgio.csv
mdb-export dati.mdb tabinv > tabinv.csv
mdb-export dati.mdb TabIVA > TabIVA.csv
mdb-export dati.mdb TabLavRipa > TabLavRipa.csv
mdb-export dati.mdb tablic > tablic.csv
mdb-export dati.mdb tabliv > tabliv.csv
mdb-export dati.mdb TabLogEventi > TabLogEventi.csv
mdb-export dati.mdb tabmag > tabmag.csv
mdb-export dati.mdb tabmet > tabmet.csv
mdb-export dati.mdb TabModifica > TabModifica.csv
mdb-export dati.mdb TabModPag > TabModPag.csv
mdb-export dati.mdb tabogg > tabogg.csv
mdb-export dati.mdb TabPercSconti > TabPercSconti.csv
mdb-export dati.mdb TabPos > TabPos.csv
mdb-export dati.mdb TabReferenze > TabReferenze.csv
mdb-export dati.mdb TabRFID > TabRFID.csv
mdb-export dati.mdb tabric > tabric.csv
mdb-export dati.mdb TabRientri > TabRientri.csv
mdb-export dati.mdb TabRipaOgg > TabRipaOgg.csv
mdb-export dati.mdb TabRitiroMetallo > TabRitiroMetallo.csv
mdb-export dati.mdb tabsca > tabsca.csv
mdb-export dati.mdb TabSconti > TabSconti.csv
mdb-export dati.mdb TabSetRipa > TabSetRipa.csv
mdb-export dati.mdb TabSMS > TabSMS.csv
mdb-export dati.mdb TabSpese > TabSpese.csv
mdb-export dati.mdb TabTessere > TabTessere.csv
mdb-export dati.mdb tabven > tabven.csv
mdb-export dati.mdb TabVenditori > TabVenditori.csv
mdb-export dati.mdb TabVerificaDB > TabVerificaDB.csv
mdb-export dati.mdb Temp2SottoscortaXLS > Temp2SottoscortaXLS.csv
mdb-export dati.mdb TempAnalisiForniXLS > TempAnalisiForniXLS.csv
mdb-export dati.mdb TempCatOIRXLS > TempCatOIRXLS.csv
mdb-export dati.mdb TempCLIXLS > TempCLIXLS.csv
mdb-export dati.mdb TempDaRiordinareCIPXLS > TempDaRiordinareCIPXLS.csv
mdb-export dati.mdb TempIncassiXLS > TempIncassiXLS.csv
mdb-export dati.mdb TempINVEXLS > TempINVEXLS.csv
mdb-export dati.mdb TempInvXLS > TempInvXLS.csv
mdb-export dati.mdb TempMAGXLS > TempMAGXLS.csv
mdb-export dati.mdb TempMovMagXLS > TempMovMagXLS.csv
mdb-export dati.mdb TempResiQta > TempResiQta.csv
mdb-export dati.mdb TempResoXLS > TempResoXLS.csv
mdb-export dati.mdb TempRipaXLS > TempRipaXLS.csv
mdb-export dati.mdb TempRitiroMetalloXLS > TempRitiroMetalloXLS.csv
mdb-export dati.mdb TempSottoscortaXLS > TempSottoscortaXLS.csv
mdb-export dati.mdb TempVALANNOXLS > TempVALANNOXLS.csv
mdb-export dati.mdb TempVarAcquistiCZXLS > TempVarAcquistiCZXLS.csv
mdb-export dati.mdb TempVEN2XLS > TempVEN2XLS.csv
mdb-export dati.mdb TempVENXLS > TempVENXLS.csv
mdb-export dati.mdb tipipag > tipipag.csv
mdb-export dati.mdb DettVenduto > DettVenduto.csv
mdb-export dati.mdb immaR > immaR.csv
mdb-export dati.mdb puntatori > puntatori.csv
mdb-export dati.mdb TabCarrelliOiR > TabCarrelliOiR.csv
mdb-export dati.mdb tabcli > tabcli.csv
mdb-export dati.mdb tabforni > tabforni.csv
mdb-export dati.mdb tablav > tablav.csv
mdb-export dati.mdb TabLogUbi > TabLogUbi.csv
mdb-export dati.mdb TabMovCarteCredito > TabMovCarteCredito.csv
mdb-export dati.mdb tabreso > tabreso.csv
mdb-export dati.mdb tabripa > tabripa.csv
mdb-export dati.mdb TabRipaUbi > TabRipaUbi.csv
mdb-export dati.mdb TabSettori > TabSettori.csv
mdb-export dati.mdb TabUltimi > TabUltimi.csv
mdb-export dati.mdb TempAcquistiCZXLS > TempAcquistiCZXLS.csv
mdb-export dati.mdb TempDaRiordinareXLS > TempDaRiordinareXLS.csv
mdb-export dati.mdb TempMultidbCZXLS > TempMultidbCZXLS.csv
mdb-export dati.mdb TempScadenXLS > TempScadenXLS.csv
Find
Reply
nio74maz
Silly Frenchman
Posts: 30
Threads: 11
Joined: Dec 2020
Reputation: 0
#14
Dec-16-2020, 08:21 AM
(Dec-15-2020, 06:58 PM)Larz60+ Wrote: see last line of post 10
https://python-forum.io/Thread-Connect-o...#pid133160

you can use following commands to export tables. I tried it and it works
Output:
mdb-export dati.mdb Cartecredito > Cartecredito.csv
mdb-export dati.mdb certificati > certificati.csv
mdb-export dati.mdb fattddt > fattddt.csv
mdb-export dati.mdb GarCalce > GarCalce.csv
mdb-export dati.mdb GarRipaCalce > GarRipaCalce.csv
mdb-export dati.mdb immagini > immagini.csv
mdb-export dati.mdb magqta > magqta.csv
mdb-export dati.mdb negozio > negozio.csv
mdb-export dati.mdb noteagg > noteagg.csv
mdb-export dati.mdb tabacc > tabacc.csv
mdb-export dati.mdb TabAcc2 > TabAcc2.csv
mdb-export dati.mdb TabCategorie > TabCategorie.csv
mdb-export dati.mdb TabCatSpese1 > TabCatSpese1.csv
mdb-export dati.mdb TabCatSpese2 > TabCatSpese2.csv
mdb-export dati.mdb TabCespiti > TabCespiti.csv
mdb-export dati.mdb tabcosto > tabcosto.csv
mdb-export dati.mdb TabCstorico > TabCstorico.csv
mdb-export dati.mdb tabcv > tabcv.csv
mdb-export dati.mdb TabDettTrasporto > TabDettTrasporto.csv
mdb-export dati.mdb tabgio > tabgio.csv
mdb-export dati.mdb tabinv > tabinv.csv
mdb-export dati.mdb TabIVA > TabIVA.csv
mdb-export dati.mdb TabLavRipa > TabLavRipa.csv
mdb-export dati.mdb tablic > tablic.csv
mdb-export dati.mdb tabliv > tabliv.csv
mdb-export dati.mdb TabLogEventi > TabLogEventi.csv
mdb-export dati.mdb tabmag > tabmag.csv
mdb-export dati.mdb tabmet > tabmet.csv
mdb-export dati.mdb TabModifica > TabModifica.csv
mdb-export dati.mdb TabModPag > TabModPag.csv
mdb-export dati.mdb tabogg > tabogg.csv
mdb-export dati.mdb TabPercSconti > TabPercSconti.csv
mdb-export dati.mdb TabPos > TabPos.csv
mdb-export dati.mdb TabReferenze > TabReferenze.csv
mdb-export dati.mdb TabRFID > TabRFID.csv
mdb-export dati.mdb tabric > tabric.csv
mdb-export dati.mdb TabRientri > TabRientri.csv
mdb-export dati.mdb TabRipaOgg > TabRipaOgg.csv
mdb-export dati.mdb TabRitiroMetallo > TabRitiroMetallo.csv
mdb-export dati.mdb tabsca > tabsca.csv
mdb-export dati.mdb TabSconti > TabSconti.csv
mdb-export dati.mdb TabSetRipa > TabSetRipa.csv
mdb-export dati.mdb TabSMS > TabSMS.csv
mdb-export dati.mdb TabSpese > TabSpese.csv
mdb-export dati.mdb TabTessere > TabTessere.csv
mdb-export dati.mdb tabven > tabven.csv
mdb-export dati.mdb TabVenditori > TabVenditori.csv
mdb-export dati.mdb TabVerificaDB > TabVerificaDB.csv
mdb-export dati.mdb Temp2SottoscortaXLS > Temp2SottoscortaXLS.csv
mdb-export dati.mdb TempAnalisiForniXLS > TempAnalisiForniXLS.csv
mdb-export dati.mdb TempCatOIRXLS > TempCatOIRXLS.csv
mdb-export dati.mdb TempCLIXLS > TempCLIXLS.csv
mdb-export dati.mdb TempDaRiordinareCIPXLS > TempDaRiordinareCIPXLS.csv
mdb-export dati.mdb TempIncassiXLS > TempIncassiXLS.csv
mdb-export dati.mdb TempINVEXLS > TempINVEXLS.csv
mdb-export dati.mdb TempInvXLS > TempInvXLS.csv
mdb-export dati.mdb TempMAGXLS > TempMAGXLS.csv
mdb-export dati.mdb TempMovMagXLS > TempMovMagXLS.csv
mdb-export dati.mdb TempResiQta > TempResiQta.csv
mdb-export dati.mdb TempResoXLS > TempResoXLS.csv
mdb-export dati.mdb TempRipaXLS > TempRipaXLS.csv
mdb-export dati.mdb TempRitiroMetalloXLS > TempRitiroMetalloXLS.csv
mdb-export dati.mdb TempSottoscortaXLS > TempSottoscortaXLS.csv
mdb-export dati.mdb TempVALANNOXLS > TempVALANNOXLS.csv
mdb-export dati.mdb TempVarAcquistiCZXLS > TempVarAcquistiCZXLS.csv
mdb-export dati.mdb TempVEN2XLS > TempVEN2XLS.csv
mdb-export dati.mdb TempVENXLS > TempVENXLS.csv
mdb-export dati.mdb tipipag > tipipag.csv
mdb-export dati.mdb DettVenduto > DettVenduto.csv
mdb-export dati.mdb immaR > immaR.csv
mdb-export dati.mdb puntatori > puntatori.csv
mdb-export dati.mdb TabCarrelliOiR > TabCarrelliOiR.csv
mdb-export dati.mdb tabcli > tabcli.csv
mdb-export dati.mdb tabforni > tabforni.csv
mdb-export dati.mdb tablav > tablav.csv
mdb-export dati.mdb TabLogUbi > TabLogUbi.csv
mdb-export dati.mdb TabMovCarteCredito > TabMovCarteCredito.csv
mdb-export dati.mdb tabreso > tabreso.csv
mdb-export dati.mdb tabripa > tabripa.csv
mdb-export dati.mdb TabRipaUbi > TabRipaUbi.csv
mdb-export dati.mdb TabSettori > TabSettori.csv
mdb-export dati.mdb TabUltimi > TabUltimi.csv
mdb-export dati.mdb TempAcquistiCZXLS > TempAcquistiCZXLS.csv
mdb-export dati.mdb TempDaRiordinareXLS > TempDaRiordinareXLS.csv
mdb-export dati.mdb TempMultidbCZXLS > TempMultidbCZXLS.csv
mdb-export dati.mdb TempScadenXLS > TempScadenXLS.csv

hello it works send me the paypal email that I offer you the case for beer, now I will try a script that does the queries
Find
Reply
Larz60+
aetate et sapientia
Super Moderators
Posts: 11,869
Threads: 473
Joined: Sep 2016
Reputation: 452
#15
Dec-16-2020, 11:25 AM
Thanks, but I don't use alcohol. I already got what I want out of helping.
nio74maz likes this post
Find
Reply
nio74maz
Silly Frenchman
Posts: 30
Threads: 11
Joined: Dec 2020
Reputation: 0
#16
Dec-20-2020, 03:31 PM
GUYS I did it I have to buy myself a case of beer, I said like this:
used 32-bit DSNs set the database with its password, then installed 32-bit python (I was wrong here)

import pyodbc
con = pyodbc.connect("DSN=ROTTURADIPALLE")
cursor = con.cursor()
cursor.execute('select * from tabgio')
for row in cursor.fetchall():
print (row)
Big Grin Big Grin Big Grin Big Grin
Find
Reply
caleb_cruze
Programmer named Tim
Posts: 7
Threads: 0
Joined: Dec 2020
Reputation: 0
#17
Jan-04-2021, 01:14 PM
Try this:

Start wizard with File ▸ New ▸ Database or use item LibreOffice Base from Windows (German) Startmenü, or use item Database in LibreOffice Quickstarter.

In the first step, select Connect to an existing database. Open the drop-down list. You can use Microsoft Access, ADO, or ODBC. The next steps depend on the chosen kind of connection. When the connection is finished, you see your chosen connection on the left side in the status bar.

Let me know if this helps you.
Regards,
Caleb
Find
Reply


Forum Jump:

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020