Import Excel File

  • i want to make a stored procedure that can import excel, without using DTS, SSIS etc..

    Thanks alot who ever will reply on my post

  • Check out OpenRowset in Books Online. Has instructions for how to do this.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • thanks...

    Now I want to copy an specific rows or column of an excel file to a sql server database....... Thanks for the reply:)

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

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