Accessing SQL SERVER through EXCEL

• Kavin-1064454

  SSC Veteran

  Points: 260

  More actions

  April 10, 2009 at 1:48 am

  #208061

  I am having lacks n rows or records in excel and I need to upload that datas in one particular table which is SQL SERVER. Please guide me to proceed.

  Thanks in advance.

• Eswin

  SSCrazy Eights

  Points: 8320

  More actions

  April 10, 2009 at 5:47 am

  #975677

  You can Import the excel sheet as a table to a database using import and Export Wizard.

  Check out this link:

  http://msdn.microsoft.com/en-us/library/ms140052(SQL.90).aspx

  Tanx 😀

• Vijaya Kadiyala

  SSCrazy Eights

  Points: 9119

  More actions

  April 10, 2009 at 9:35 am

  #975846

  Hi

  Check out the below link

  http://support.microsoft.com/default.aspx/kb/306125

  Thanks -- Vijaya Kadiyala
  www.dotnetvj.com
  SQL Server Articles For Beginers