Connect old access datbase .mdb - Printable Version +- Python Forum (https://python-forum.io) +-- Forum: Python Coding (https://python-forum.io/forum-7.html) +--- Forum: Networking (https://python-forum.io/forum-12.html) +--- Thread: Connect old access datbase .mdb (/thread-31450.html) Pages:
1
2
|
RE: Connect old access datbase .mdb - Larz60+ - Dec-15-2020 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) ); RE: Connect old access datbase .mdb - nio74maz - Dec-15-2020 You are the best, but I must to do it work in windows 10 RE: Connect old access datbase .mdb - Larz60+ - Dec-15-2020 see last line of post 10 https://python-forum.io/Thread-Connect-old-access-datbase-mdb?pid=133160#pid133160 you can use following commands to export tables. I tried it and it works
RE: Connect old access datbase .mdb - nio74maz - Dec-16-2020 (Dec-15-2020, 06:58 PM)Larz60+ Wrote: see last line of post 10 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 RE: Connect old access datbase .mdb - Larz60+ - Dec-16-2020 Thanks, but I don't use alcohol. I already got what I want out of helping. RE: Connect old access datbase .mdb - nio74maz - Dec-20-2020 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) RE: Connect old access datbase .mdb - caleb_cruze - Jan-04-2021 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 |