Forum Replies Created

Viewing 5 posts - 121 through 125 (of 125 total)

  • RE: GLOBAL FUNCTION

    Jonathan,

    If i want edit that what is the procedure.

  • RE: OLEDB Connection

    What kind of network library enabled on your SQL server?.

    Thanks,

    Sreeni.

  • RE: Connecting Excel file via ADO.

    Try This .............

    Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strWebFilePath & ";Extended Properties="""";Excel 8.0;HDR=Yes;"

    Conn.Mode = adModeReadWrite

    Conn.Open

  • RE: HTML to SQL

    Try this..

    CREATE TABLE #file (line varchar(255) null)

    INSERT #file EXEC master..xp_cmdshell 'Type D:\temp.html'

    SELECT * FROM #file

    DROP TABLE #file

  • RE: GLOBAL FUNCTION

    Jonathan,

    Thanks, it worked for me. But is it compatable for all versions?.

Viewing 5 posts - 121 through 125 (of 125 total)