Save excel file using ADODB object

Author Message
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)
0
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
 
#1
    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)
    0
    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.
     
    #2

      Online Bookmarks Sharing: Share/Bookmark

      Jump to:

      Current active users

      There are 0 members and 1 guests.

      Icon Legend and Permission

      • New Messages
      • No New Messages
      • Hot Topic w/ New Messages
      • Hot Topic w/o New Messages
      • Locked w/ New Messages
      • Locked w/o New Messages
      • Read Message
      • Post New Thread
      • Reply to message
      • Post New Poll
      • Submit Vote
      • Post reward post
      • Delete my own posts
      • Delete my own threads
      • Rate post

      2000-2012 ASPPlayground.NET Forum Version 3.9