Post reply

Import

  • April 23, 2010 at 1:27 pm

    #146607

    I had a dts package . When I run the package the data gets loaded into excel. The data gets imported into the application.

    But when I use ssis by using the same logic to load the data into the excel file the data gets loaded into the Excel.

    But when I Import the excel to the application.The excel sheet doesn't get imported. It tells to me that a valid spreadsheet is required.

    Any IDEAS. Please help

    Thank You,

  • April 23, 2010 at 2:30 pm

    #1157135

    I would ask that you compare the excel files generated by each process. How are they different. Given the information you have provided this is about all I can suggest.

    CEWII

  • April 23, 2010 at 3:04 pm

    #1157150

    the excel files are looking same

  • April 23, 2010 at 3:16 pm

    #1157156

    I think you need to go deep than looks..

    Same worksheet names?

    Same column formatting?

    Are the files the same size..

    CEWII

  • April 28, 2010 at 8:06 am

    #1158942

    work sheet names are same,

    columns have same data types with same size

    except for varchar

    varchar will be used as dt_wstr in excel.bt i am using the same size in dt_wstr.

    excel file sizes are different I think so.

    i don't have the access to the folder where i can check the files.

    after creating the excel files if i open them on another computer and then save it and then import

    to the application . Then the size of the excel changes. then it works.

    i want my excel sheets to opened directly by the application.

    not by opening them saving them and then doing the Import.

    Can you please suggest a way to do this.

  • April 28, 2010 at 8:43 am

    #1158996

    I'm wondering if perhaps the application is looking for a different version of the Excel file.

    When you open and save it again, what version of Excel are you using? Also can you tell what version of the file Excel thinks it is?

    It is also a little problematic that we don't know what problem the application has with the file. It worked and now it doesn't, is not really much to go on..

    I am about 100% sure that it is something really simple..

    CEWII

  • April 29, 2010 at 12:14 pm

    #1159967

    i am using excel 2003 sp2

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

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