Salve ragazzi ho la necessità di leggere un file di Excell ma ho un problema dovuto alla sua struttura.
Praticamente ho 6 colonne di questo tipo:
Comm.Pref Mail
Comm.Pref Email
Comm.Pref Share
Comm.Pref Phone
Comm.Pref Mobile Phone
Comm.Pref Sms
Il problema è che in fase di importazione il "puntino" da fastidio generando l'errore classico in cui mi dice che la colonna non viene trovata.
Se levo i puntini funziona tutto correttamente.codice:'titoli dei campi da estrarre response.write "<table border='1'><tr>" response.write "<td>Registration Date</td>" response.write "<td>Company Name</td>" response.write "<td>Gender Title</td>" response.write "<td>First Name</td>" response.write "<td>Last Name</td>" response.write "<td>Birth date</td>" response.write "<td>Email address</td>" response.write "<td>Comm. Pref. Mail</td>" response.write "<td>Comm. Pref Email</td>" response.write "<td>Comm. Pref. Share</td>" response.write "<td>Comm. Pref. Phone</td>" response.write "<td>Comm. Pref. Mobile Phone</td>" response.write "<td>Comm. Pref. Sms</td>" response.write "<td>Cpc number</td>" response.write "<td>Serial number</td>" response.write "<td>Date purchased</td>" response.write "<td>Purchase place type</td>" response.write "<td>Dealer name</td>" response.write "<td>Dealer city</td>" response.write "<td>Outlet factory</td>" response.write "<td>Product registration address street</td>" response.write "<td>Product registration address house number</td>" response.write "<td>Product registration address city</td>" response.write "<td>Product registration address country</td>" response.write "<td>Product registration address day phone</td>" response.write "</tr>" do while not rs.EOF response.write "<tr>" response.write "<td>" response.write rs("Registration date") response.write "</td>" response.write "<td>" response.write rs("Company name") response.write "</td>" response.write "<td>" response.write rs("Gender title") response.write "</td>" response.write "<td>" response.write rs("First name") response.write "</td>" response.write "<td>" response.write rs("Last name") response.write "</td>" response.write "<td>" response.write rs("Birth date") response.write "</td>" response.write "<td>" response.write rs("Email address") response.write "</td>" response.write "<td>" response.write rs("Comm.Pref Mail") response.write "</td>" response.write "<td>" response.write rs("Comm.Pref Email") response.write "</td>" response.write "<td>" response.write rs("Comm.Pref Share") response.write "</td>" response.write "<td>" response.write rs("Comm.Pref Phone") response.write "</td>" response.write "<td>" response.write rs("Comm.Pref MobilePhone") response.write "</td>" response.write "<td>" response.write rs("Comm.Pref Sms") response.write "</td>" response.write "<td>" response.write rs("CPC Number") response.write "</td>" response.write "<td>" response.write rs("Serialnumber") response.write "</td>" response.write "<td>" response.write rs("Date purchased") response.write "</td>" response.write "<td>" response.write rs("PurchasePlace type") response.write "</td>" response.write "<td>" response.write rs("Dealer name") response.write "</td>" response.write "<td>" response.write rs("Dealer city") response.write "</td>" response.write "<td>" response.write rs("Outletfactory") response.write "</td>" response.write "<td>" response.write rs("ProductRegistration address street") response.write "</td>" response.write "<td>" response.write rs("ProductRegistration address house number") response.write "</td>" response.write "<td>" response.write rs("ProductRegistration address city") response.write "</td>" response.write "<td>" response.write rs("ProductRegistration address county") response.write "</td>" response.write "<td>" response.write rs("ProductRegistration address postal code") response.write "</td>" response.write "<td>" response.write rs("ProductRegistration address day phone") response.write "</td>" response.write "<td>" response.write rs("ProductRegistration address mobile phone") response.write "</td>" response.write "</tr>"
C'è un modo per far leggere alle intestazioni i "puntini"?
Grazie a tutti in anticipo.