Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    1

    Unanswered: Insert Openrowset

    dim inserttxt as string

    inserttxt = "insert openrowset ('Microsoft.Jet.OLEDB.4.0', 'Text;Database=C:\Documents and Settings\sarathn\Desktop',test#csv) Select item, on_hand_qty as onhand from location_inventory"


    Set con1 = New ADODB.Connection

    con1.Open ("Provider=sqloledb;" & _
    "Data Source=PRODCLUSTER;" & _
    "Initial Catalog=warehousemgt;" & _
    "User Id=**;" & _
    "Password=**")

    rs = con1.Execute(inserttxt)

    This code i am using in VB. This runs on our live SQL server(PRODCLUSTER). Problem is the we are not authorised to create any file on the live server. This query will write the output to a csv file in that location.

    I want the query output to be on another PC on the network. How do i do it?

    Thanks

  2. #2
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Gotta share a folder (create a sharepoint) from that PC with the appropriate privs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •