Post reply

Skip n rows while importing from Excel Sheet to SQL Server 2000 table.

  • December 20, 2007 at 2:36 am

    #119486

    Hi!

    I want to skip first few rows from spread sheet while importing into table, as the & column header is @row# 4 & actual data @row#5.

    I've explored Openrowset & OpendataSorce. But couldn't find any option.

    Thanks in adv.

    Ashesh

    Thanks,
    Ashesh

  • December 20, 2007 at 3:37 am

    #761690

    Could you perhaps delete this thread please, as it's in completely the wrong forum.

    There's no need to post in multiple forums, the regulars read all the forums

    Thread continued here

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 20, 2007 at 5:14 am

    #761709

    I tried to delete this particular post. But failed.

    Sorry for the inconvenience.

    Thanks,

    Ashesh

    Thanks,
    Ashesh

Viewing 3 posts - 1 through 2 (of 2 total)

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