Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2012

    Unanswered: How to generate an excel(.XLS) file with a VB script?

    I want to create an excel file with .xls by using VB script.

    Because i want to create a DTS package for our requirement. DTS accepts excel files which has .xls extension only.

    Please help me. Thanks in advance.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Where does the data come from before you process it with your VB script? Many data sources have the ability to create XLS files as their output, so it might be easiest to simply create the data in this form instead of writing a VB script to transform existing data into the Excel .XLS format.

    Which version of DTS is running on your SQL Server? There are several flavors/generations of the DTS product, and each of them offers different opportunities and restrictions that will affect your choices.

    Do you have the option of using SSIS instead of DTS? SSIS is a much more mature product than DTS was, and offers many more features.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Tags for this Thread

Posting Permissions

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