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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.