Click here to Skip to main content
15,896,432 members
Home / Discussions / Web Development
   

Web Development

 
AnswerRe: What's With h1, h2 ? ? ? Pin
Macotti20-Oct-10 1:22
Macotti20-Oct-10 1:22 
GeneralRe: What's With h1, h2 ? ? ? Pin
W Balboos, GHB8-Nov-10 2:14
W Balboos, GHB8-Nov-10 2:14 
GeneralRe: What's With h1, h2 ? ? ? Pin
Macotti8-Nov-10 14:27
Macotti8-Nov-10 14:27 
AnswerRe: What's With h1, h2 ? ? ? Pin
W Balboos, GHB9-Nov-10 7:29
W Balboos, GHB9-Nov-10 7:29 
GeneralRe: What's With h1, h2 ? ? ? Pin
Macotti9-Nov-10 15:24
Macotti9-Nov-10 15:24 
GeneralRe: What's With h1, h2 ? ? ? Pin
W Balboos, GHB10-Nov-10 3:21
W Balboos, GHB10-Nov-10 3:21 
QuestionExport excel data to SQL server in ASP Pin
priyaahh23-Sep-10 23:05
priyaahh23-Sep-10 23:05 
AnswerRe: Export excel data to SQL server in ASP Pin
Poonam Gandash6-Oct-10 2:40
Poonam Gandash6-Oct-10 2:40 
' Path to excel file
z="uploadasp/contact_data.xls;"
Path = Server.MapPath(z)

SQL_Query = "SELECT * FROM [Commercial$]"
Driver ="{Microsoft Excel Driver (*.xls)}"
DataSource = "DBQ=" & Path & ";"
DataSource = DataSource & "DefaultDir=" & Path & ";"
DataSource = DataSource & "Driver=" & Driver & ";"
DataSource = DataSource & "FIL=excel 5.0;ReadOnly=1;"

Set MyConn =Server.CreateObject("ADODB.Connection")
MyConn.ConnectionTimeout = 15
MyConn.CommandTimeout = 30
MyConn.Open DataSource




'Set MyConn = Server.CreateObject("ADODB.Connection")
'Set MyConn = Server.CreateObject("ADODB.Recordset")
'strBaseFilePath ="uploadasp/contact_data.xls"
'MyConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
'"Data Source=" & Server.MapPath(strBaseFilePath) & ";" & _
'"Extended Properties=""Excel 8.0;"""
'RS.Open SQL_Query, MyConn, adOpenStatic



'Lets loop through the data and output it into a HTML table
Set RS = MyConn.Execute(SQL_Query)

IF RS.EOF THEN
'There is no data to show
tot=0
ELSE

'Lets output the field names

' FOR EACH Field IN RS.Fields

' NEXT

'Now we will output each row of the data
tot=0
tota=0

DO WHILE NOT RS.EOF
if rs.fields(0)<>"" then


Set rs4 = Server.CreateObject("ADODB.Recordset")
rs4.open "select * from data where 1<>1",Con,1,3
rs4.addnew

IF rs.Fields(0)<>"" THEN RS4("name")=rs.Fields(0)
IF rs.Fields(1)<>"" THEN RS4("surname")=rs.Fields(1)
IF rs.Fields(2)<>"" THEN RS4("primary_email")=rs.Fields(2)

rs4.UPDATE
end if

RS.MoveNext
LOOP

END IF
RS.Close
Set RS = nothing
MyConn.Close
Set MyConn = nothing









===================

Hope this code will help
QuestionFree Adobe Flash Template Site Pin
jaglenn23-Sep-10 10:23
jaglenn23-Sep-10 10:23 
AnswerRe: Free Adobe Flash Template Site Pin
DaveAuld23-Sep-10 10:31
professionalDaveAuld23-Sep-10 10:31 
GeneralRe: Free Adobe Flash Template Site Pin
DaveAuld24-Sep-10 12:17
professionalDaveAuld24-Sep-10 12:17 
QuestionHow to Construct the Sidebar Menu Like the one at the left in the Codeproject Pin
sajid.salim.khan23-Sep-10 4:45
sajid.salim.khan23-Sep-10 4:45 
QuestionPROBLEM WITH IE8 AND ABOVE BROWSERS Pin
vallu_hari15-Sep-10 20:08
vallu_hari15-Sep-10 20:08 
AnswerRe: PROBLEM WITH IE8 AND ABOVE BROWSERS Pin
R. Giskard Reventlov15-Sep-10 20:35
R. Giskard Reventlov15-Sep-10 20:35 
AnswerRe: PROBLEM WITH IE8 AND ABOVE BROWSERS Pin
Eduard Keilholz22-Sep-10 1:47
Eduard Keilholz22-Sep-10 1:47 
QuestionConvert XML Google Calendar into RSS feed with feed43.com Pin
mundilev14-Sep-10 11:00
mundilev14-Sep-10 11:00 
QuestionVS2003 error Pin
Ajay Kale New13-Sep-10 17:35
Ajay Kale New13-Sep-10 17:35 
Questionre VS2003 error Pin
Ajay Kale New13-Sep-10 17:34
Ajay Kale New13-Sep-10 17:34 
QuestionCSS Image Sprites in IE7 Pin
hxhl957-Sep-10 14:51
hxhl957-Sep-10 14:51 
AnswerRe: CSS Image Sprites in IE7 Pin
Gerben Jongerius8-Sep-10 1:59
Gerben Jongerius8-Sep-10 1:59 
GeneralRe: CSS Image Sprites in IE7 Pin
hxhl958-Sep-10 12:15
hxhl958-Sep-10 12:15 
AnswerRe: CSS Image Sprites in IE7 Pin
jahangir_ahmad12-Sep-10 3:22
jahangir_ahmad12-Sep-10 3:22 
QuestionSending Online Order To Specific Printer Pin
mrutkunas6-Sep-10 7:22
mrutkunas6-Sep-10 7:22 
AnswerRe: Sending Online Order To Specific Printer Pin
Not Active6-Sep-10 9:21
mentorNot Active6-Sep-10 9:21 
GeneralRe: Sending Online Order To Specific Printer Pin
mrutkunas6-Sep-10 16:33
mrutkunas6-Sep-10 16:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.