Post reply

from txt to XLS

  • November 1, 2005 at 8:13 am

    #110735

    Hi all,

     

    I am transfering data from Text file to Excel file but the schedule fails after it runs first time saying that the file is open. How can i make it work that it will override the data everyday when job runs?

    Thanks

  • November 1, 2005 at 8:21 am

    #601564

    I've seen similar items with Excel. You might try a drop table/ create table (exec sql task) at the beginning of the package. I used to use two tasks and use the "create" button in the transform package to get the create table code.

  • November 1, 2005 at 8:30 am

    #601570

    how can i drop in excel!

    thanks

     

  • November 1, 2005 at 9:04 am

    #601582

    Use the create code and change to be "drop table xxx"

    Remove all the column stuff

  • November 1, 2005 at 9:48 am

    #601605

    does it save it as a task because the package will run everynight! so i want to drop table in excel file first and then recreate it.! what could be the porcedure?

    thanks

  • November 1, 2005 at 12:59 pm

    #601664

    Hi,

    I found a WSH (Windows Scripting Host) script that does import from csv file to Excel. You can modify the script if your text file is not csv (comma-separated). This script is like 1 page with a lot of comments, so it is very readable.

    http://ourworld.compuserve.com/homepages/guenter_Born/WSHBazaar/WSHExcel1.htm

    Excel: Import a CSV file

    You may schedule this script in Windows Scheduled Tasks. It will let you not to use DTS at all.

    MORE, Just Added:

    I tested this script, it works well. It does some outputs and printouts after initial load for the example, you have to remove this from non-ineractive script

    Regards,Yelena Varsha

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply