how to import data from excel to database with full data of a table?

• Sivaganesh Tamilvendhan

  Hall of Fame

  Points: 3498

  More actions

  June 9, 2012 at 4:31 am

  #262737

  here i just tried to import a datas from excell to database but it import half of the datas only not fully

  in excell it has id data of 50000 data but in database only 1600 datas only copied

• Haining

  SSCrazy

  Points: 2118

  More actions

  June 9, 2012 at 10:21 am

  #1499028

  Sounds like you want to import a Excel table to SQL Server database.

  Could you provide more detail about your question or problem?

  Such as,

  the tool you used to import the data,

  the Excel table data format,

  any error message you have ever encountered... etc.

  Those information would be helpful to identify your problem, so that others could help you.