DwZone Forum DwZone Forum
Welcome to the DwZone-it Forum
 
  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  
    RegisterRegister -->   LoginLogin  
Import/Export Tools  
DwZone Forum Index -> Import/Export Tools
.
Moderators: AdministratorsModerators 
Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.
New Topic Search for
 View     Per page     Messages Since 
Messages 81 to 88 of 88 (Total: 87) First |  Prev |  Next |  Last  
 Subject Author Date  
   Re: How to force download (not use cached copy)  
View this persons public profile  Gianluigi   9:48 31 Jan 2014  
   Re: How to force download (not use cached copy)  
View this persons public profile  DennisMaier   10:00 31 Jan 2014  
   Re: How to force download (not use cached copy)  
View this persons public profile  Gianluigi   11:30 31 Jan 2014  
   Re: How to force download (not use cached copy)  
View this persons public profile  DennisMaier   13:27 31 Jan 2014  
   Re: How to force download (not use cached copy)  
View this persons public profile  Gianluigi   15:04 31 Jan 2014  
   Re: How to force download (not use cached copy)  
View this persons public profile  DennisMaier   15:18 31 Jan 2014  
    Excel Import  
View this persons public profile  MamO   17:07 2 Dec 2013  
 
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>


 
Reply to this current thread  View this persons public profile  Send Private Message
   Re: Excel Import  
View this persons public profile  Gianluigi   10:21 3 Dec 2013  
Last Visit: Monday 29 Apr, 2024 0:55 am First |  Prev |  Next |  Last  
 Login
Username:  Password:    
Read Message Read Message   Unread message Unread message
Read message [popular] Read message [popular]   Unread message [popular] Unread message [popular]
Read message [locked] Read message [locked]   Unread message [locked] Unread message [locked]
All times are GMT-2

Jump to: