Esportazione dati da Access ad Excell con più di 65000 report

%3CLINGO-SUB%20id%3D%22lingo-sub-2284695%22%20slang%3D%22en-US%22%3EEsportazione%20dati%20da%20Access%20ad%20Excell%20con%20pi%C3%B9%20di%2065000%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2284695%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%3EBuongiorno%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3ESto%20usando%20Access%202007-2016%20e%20dovendo%20esportare%20su%20foglio%20di%20Excell%20pi%C3%B9%20di%2065000%20report%20il%20sistema%20mi%20indica%20di%20dividere%20il%20record%20in%20due%20o%20pi%C3%B9%20gruppi%20e%20di%20incollarlo%20un%20al%20volta.%3C%2FFONT%3E%3CBR%20%2F%3E%3CFONT%3EMi%20chiedo%20se%20esiste%20una%20procedura%20che%20mi%20permette%20di%20esportare%20in%20un%20unico%20soluzione%20i%20dati%20per%20evitare%20errori%20di%20%22incollaggio%22.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3EGrazie%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2284695%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2285110%22%20slang%3D%22en-US%22%3ERe%3A%20Esportazione%20dati%20da%20Access%20ad%20Excell%20con%20pi%C3%B9%20di%2065000%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2285110%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1035548%22%20target%3D%22_blank%22%3E%40Stella_Ferrara%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E(Translated%20by%20Google)%3C%2FP%3E%0A%3CP%3ENella%20finestra%20di%20dialogo%20Esporta%2C%20deseleziona%20la%20casella%20di%20controllo%20%22Esporta%20dati%20con%20formattazione%22.%20%C3%88%20quindi%20possibile%20esportare%20fino%20a%201%20milione%20di%20record.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2285124%22%20slang%3D%22en-US%22%3ERe%3A%20Esportazione%20dati%20da%20Access%20ad%20Excell%20con%20pi%C3%B9%20di%2065000%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2285124%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1035548%22%20target%3D%22_blank%22%3E%40Stella_Ferrara%3C%2FA%3E%26nbsp%3BAlternatively%2C%20connect%20to%20it%20with%20Power%20Query%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PQ.png%22%20style%3D%22width%3A%20527px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F275252iDF439AE4989B88BF%2Fimage-dimensions%2F527x474%3Fv%3Dv2%22%20width%3D%22527%22%20height%3D%22474%22%20role%3D%22button%22%20title%3D%22PQ.png%22%20alt%3D%22PQ.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Buongiorno

Sto usando Access 2007-2016 e dovendo esportare su foglio di Excell più di 65000 report il sistema mi indica di dividere il record in due o più gruppi e di incollarlo un al volta.
Mi chiedo se esiste una procedura che mi permette di esportare in un unico soluzione i dati per evitare errori di "incollaggio".

Grazie

5 Replies

@Stella_Ferrara 

(Translated by Google)

Nella finestra di dialogo Esporta, deseleziona la casella di controllo "Esporta dati con formattazione". È quindi possibile esportare fino a 1 milione di record.

@Stella_Ferrara Alternatively, connect to it with Power Query? 

PQ.png

@Riny_van_Eekelen 

Grazie..

ma non sono riuscita a risolvere il problema con il percorso indicato

Grazie ....ma è' quello che avevo già fatto e non mi fa esportare più di 65000 su foglio excelle

@Stella_Ferrara 

Sei sicuro di aver selezionato Cartello Excel (*.xlsx) come formato file?