SQL Server Performance

excel load

Discussion in 'SQL Server DTS-Related Questions' started by ryanFX, Jun 17, 2005.

  1. ryanFX New Member

    what is the best way to load an excel file which contains multiple worksheets? we are currently using a custom sp which loops through the sheets, but the process is too long. any ideas?

    thanks

    ryan
  2. Madhivanan Moderator

  3. dineshasanka Moderator

  4. Madhivanan Moderator

    Dinesh, that link does not work


    Madhivanan

    Failing to plan is Planning to fail
  5. satya Moderator

  6. Madhivanan Moderator

    No
    Still it doesnot work
    I think some characters are missing between kb and en-us(I am not sure)


    Madhivanan

    Failing to plan is Planning to fail
  7. Argyle New Member

    http://support.microsoft.com/default.aspx?scid=kb;en-us;Q321686
  8. Madhivanan Moderator

    Thanks Argyle


    Madhivanan

    Failing to plan is Planning to fail

Share This Page