laosu
-
Total Posts
:
2
- Scores: 0
-
Reward points
:
0
- Joined: 3/8/2011
-
Status: offline
|
Save excel file using ADODB object
Sunday, March 27, 2011 6:41 PM
( permalink)
Hi, I need to save the data into an excel file. My Sniplet of codes as below: Set objConn = Server.CreateObject("ADODB.Connection") Set objRS = Server.CreateObject("ADODB.Recordset") 'after doing update to the file, i need to save it...anyone has idea?? 'objRS.Save "C:\save.xls" -> does not works for me. Please advice
|
|
|
|
ehvbs
-
Total Posts
:
3320
- Scores: 110
-
Reward points
:
0
- Joined: 6/22/2005
- Location: Germany
-
Status: offline
|
Re:Save excel file using ADODB object
Monday, March 28, 2011 12:09 AM
( permalink)
Do some research wrt "open connection to excel table=sheet", "INSERT/SELECT INTO", and "external database". For more/other advice publish more details about your problem.
|
|
|
|