Import Excel File

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Import Excel File

Import Excel File

Rate Topic

Display Mode

Topic Options

Author

Message

wallydelgado

Posted Monday, August 04, 2008 3:56 AM

Grasshopper

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

GSquared

Posted Monday, August 04, 2008 11:36 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

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

wallydelgado

Posted Tuesday, August 05, 2008 1:55 AM

Grasshopper

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 »

Permissions