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 Newbies » 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:55 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 #1032840

Henrico Bekker

Posted Friday, December 10, 2010 12:34 AM

SSCommitted

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

Use the built-in ETL tool....

Right click your destination database and select Tasks, Import Data...follow the steps.....

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

Post #1032860

GilaMonster

Posted Friday, December 10, 2010 1:01 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:18 PM
Points: 37,744, Visits: 30,025

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1032839-392-1.aspx

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1032865

« Prev Topic | Next Topic »

Permissions