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 data from excel file to sql server database Expand / Collapse
Author
Message
Posted Thursday, December 9, 2010 10:53 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Friday, December 10, 2010 12:32 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, August 28, 2014 2:39 AM
Points: 1,880, Visits: 2,846
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
Posted Friday, December 10, 2010 12:35 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 11, 2014 7:23 AM
Points: 2,668, Visits: 5,924
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 »

Add to briefcase

Permissions Expand / Collapse