import data from excel file to sql server database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » import data from excel file to sql server...

import data from excel file to sql server database

Rate Topic

Display Mode

Topic Options

Author

Message

gupta.sreekanth

Posted Thursday, December 09, 2010 10:53 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, April 20, 2011 2:30 AM
Points: 19, Visits: 43

plz..........help any one .....how to import data from excel file to sql server database

Post #1032837

Henrico Bekker

Posted Friday, December 10, 2010 12:32 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:24 AM
Points: 1,871, Visits: 2,692

Duplicate Post.
All replies here: http://www.sqlservercentral.com/Forums/Topic1032840-1292-1.aspx

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.

Post #1032859

Mike John

Posted Friday, December 10, 2010 12:35 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 5:21 AM
Points: 2,637, Visits: 4,542

Sql Server integration services will let you (among many other things) read from Excel and insert into a table. The Import Wizard will even generate most of what is needed for you.

I suggest you have a read about both in Books On Line and come back with specific questions if you have a problem.

Mike

Post #1032862

« Prev Topic | Next Topic »

Permissions