 |
Ciao, ho impostato la pagina ed il file seguendo le tue indicazioni ma ottengo questo errore:
Some errors in the ExcelImport Number Description Position -2147217900 Row: 0 - Err: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. INSERT INTO TRACKING (NOMINATIVO DESTINATARIO,INDIRIZZO DESTINATARIO,CAP DESTINATARIO,CITTA DESTINATARIO,PV DESTINATARIO,CORRIERE,TRACKING) VALUES ('XXXXXXXXXXXXXXXXXXXXXXXXX','VIA XXXXXXXXXXXXX','16121','GENOVA','GE','SDA','AA345678T') ImportData -2147217900 Row: 1 - Err: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. INSERT INTO TRACKING (NOMINATIVO DESTINATARIO,INDIRIZZO DESTINATARIO,CAP DESTINATARIO,CITTA DESTINATARIO,PV DESTINATARIO,CORRIERE,TRACKING) VALUES ('XXXXXXXXXXXXXXX','VIA XXXXXXXXXXXXX XX','17028','SPOTORNO','SV','DHL','RR234567') ImportData -2147217900 Row: 2 - Err: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. INSERT INTO TRACKING (NOMINATIVO DESTINATARIO,INDIRIZZO DESTINATARIO,CAP DESTINATARIO,CITTA DESTINATARIO,PV DESTINATARIO,CORRIERE,TRACKING) VALUES ('XXXXXXXXXXXXXXXXXX','VIA XXXXXXXXXXXXXX','10034','CHIVASSO','TO','DHL','RR123456') ImportData -2147217900 Row: 3 - Err: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. INSERT INTO TRACKING (NOMINATIVO DESTINATARIO,INDIRIZZO DESTINATARIO,CAP DESTINATARIO,CITTA DESTINATARIO,PV DESTINATARIO,CORRIERE,TRACKING) VALUES ('XXXXXXXXXXX','XXXXXXXXXXXXXX XX','60033','CHIARAVALLE','AN','Ups','123456-ASD123') ImportData
... questo รจ il codice in HTML
<table border=1><tr><td colspan=3>Some errors in the ExcelImport</td></tr><tr><td>Number</td><td>Description</td><td>Position</td></tr><tr><td>-2147217900</td><td>Row: 0 - Err: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.<br>INSERT INTO TRACKING (NOMINATIVO DESTINATARIO,INDIRIZZO DESTINATARIO,CAP DESTINATARIO,CITTA DESTINATARIO,PV DESTINATARIO,CORRIERE,TRACKING) VALUES ('XXXXXXXXXX','VIA XXXXXXXX 33/R','16121','GENOVA','GE','SDA','AA345678T')</td><td>ImportData</td></tr><tr><td>-2147217900</td><td>Row: 1 - Err: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.<br>INSERT INTO TRACKING (NOMINATIVO DESTINATARIO,INDIRIZZO DESTINATARIO,CAP DESTINATARIO,CITTA DESTINATARIO,PV DESTINATARIO,CORRIERE,TRACKING) VALUES ('XXXXXXXXXXXX','VIA XXXXXXXX','17028','SPOTORNO','SV','DHL','RR234567')</td><td>ImportData</td></tr><tr><td>-2147217900</td><td>Row: 2 - Err: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.<br>INSERT INTO TRACKING (NOMINATIVO DESTINATARIO,INDIRIZZO DESTINATARIO,CAP DESTINATARIO,CITTA DESTINATARIO,PV DESTINATARIO,CORRIERE,TRACKING) VALUES ('XXXXXXXXXXXXXXX.','VIA XXXXXXXXX XX','10034','CHIVASSO','TO','DHL','RR123456')</td><td>ImportData</td></tr><tr><td>-2147217900</td><td>Row: 3 - Err: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.<br>INSERT INTO TRACKING (NOMINATIVO DESTINATARIO,INDIRIZZO DESTINATARIO,CAP DESTINATARIO,CITTA DESTINATARIO,PV DESTINATARIO,CORRIERE,TRACKING) VALUES ('xxxxxxXXXX','CORSO XXXXXXXXXXXX','60033','CHIARAVALLE','AN','Ups','123456-ASD123')</td><td>ImportData</td></tr></table> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Documento senza titolo</title> </head>
<body> </body> </html> <script language="javascript"> var GoUpload var isMAC = (navigator.userAgent.toLowerCase().indexOf("mac") != -1); var isIE = document.all; var isNS6 = (!document.all && document.getElementById ? true : false); var isNS7 = (navigator.userAgent.toLowerCase().indexOf("netscape/7") != -1); var dwz_SendForm = false function dwzImportProgressBar(){ if(dwz_SendForm){ return true } dimW = 350 dimH = 210 PosL = (screen.width-dimW)/2 PosT = (screen.height-dimH)/2 ProgressURL = '/dwzExport/FrameSet.asp?ProgressPage=0&PageID=693097832' mailWin = window.open(ProgressURL,'progressImportBarPage','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no,width='+dimW+',height='+dimH+',top='+PosT+',left='+PosL) dwz_SendForm = true setTimeout('dwzSendForm()',500) return false } function dwzSendForm(){ var el = document.getElementsByTagName('FORM') el[0].submit() } </script>
|
|
|
|
|