Search results for query: *

  1. P

    DTS SQL to Excel(overwriting existing file)

    SQL2000 I am trying to set up a DTS package to download data in an Excel format for analysis on a daily basis. I want it to overwrite the existing Excel file. How can I set this up? Is this set up in the query code and if so, how can I do this via designer? I am not well versed in SQL coding...
  2. P

    accessing data in SQL by date problem

    Resolved Got it...needed to enclose date variable with an apostraphe.
  3. P

    accessing data in SQL by date problem

    VS/VB2005 - SQL2000 I am using the following to try getting data from a SQL db: SQLCommandH = "select * from DeliveryTransH where userid = " & "'" & auserin & " '" & _ " and idate = " & Today ' & " and department = " & "'" & adeptin & "'" It is not returning any records. The value in Today is...
  4. P

    creating forms error

    I am using VB in VS 2005. I have created a windows application. when I try to run in VS I get the following error: InvalidOperationException was unhandled...An error occurred creating the form. See Exception.InnerException for details. The error is: That assembly does not allow partially...
Back
Top