Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sparhawk83

    Delete rows from excel sheet using vbscript in DTS

    Thanks Alex, that works fine as a replacement for just having a line of: 'xlApp.Range("F2:F873").Select' I'll let you know how I go with working out a solution, G
  2. sparhawk83

    Delete rows from excel sheet using vbscript in DTS

    It would be the latter of your thoughts, I have to do the number convert to cover the maximum number of rows, so on Monday it could be 873 but on Tuesday it could be 800, Unfortunately I can't remember but I'll do another search of the web using the same criteria, chances are I'll find it...
  3. sparhawk83

    Delete rows from excel sheet using vbscript in DTS

    Hi folks, I am using a DTS package to first copy a template excel file, then populate it with pre-defined data from a view, then convert the numerical data back to being numerical using VBScript within the DTS package as I have not found a way to get SQL Server to output the data as a number...

Part and Inventory Search

Back
Top