Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Import Excel File Expand / Collapse
Author
Message
Posted Monday, August 4, 2008 3:56 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 6, 2009 7:35 PM
Points: 10, Visits: 51
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
Post #545961
Posted Monday, August 4, 2008 11:36 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, December 18, 2014 9:58 AM
Points: 13,872, Visits: 9,600
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
Post #546262
Posted Tuesday, August 5, 2008 1:55 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 6, 2009 7:35 PM
Points: 10, Visits: 51
thanks...

Now I want to copy an specific rows or column of an excel file to a sql server database....... Thanks for the reply:)
Post #546556
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse