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 04, 2008 3:56 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 06, 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 04, 2008 11:36 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Monday, April 14, 2014 1:34 PM
Points: 15,442, Visits: 9,588
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 05, 2008 1:55 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 06, 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