Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005
    Location
    Green Bay
    Posts
    201

    Unanswered: DTS for Excel problem

    Hello

    I have a problem and need some assistance.
    I have a SS that I am loading into a SQL2000 database
    I am using DTS for this.
    Previously uses used an ADP file to load the spreadsheet.

    My problem is that the ADP file uses the ACTIVESHEET for its import.
    And the in the DTS you must select the SS you wish to insert.
    And the SS name is not standard.

    I am trying to use the ADP file and rename the worksheet
    any idea how to do this or any idea howelse I can accomplish my goal.

    TIA

  2. #2
    Join Date
    Apr 2004
    Location
    The Netherlands
    Posts
    29

    First what does SS and ADP mean?

    I will try to help but what does SS and ADP mean? With this explained I can try to help you.

    DePrins

  3. #3
    Join Date
    Jan 2005
    Location
    Green Bay
    Posts
    201

    SS / ADP Definintions

    SS = Excel Spreadsheet within a workbook
    ADP = MIcrosoft Access file

    I have a spreadsheet with a non specific name
    I transfer that file to a shared drive and need to rename the ActiveSheet there. Using access or SQL Server

  4. #4
    Join Date
    Apr 2004
    Location
    The Netherlands
    Posts
    29

    Explaination SS and ADP

    Thanks, i will look into it.

Posting Permissions

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