Import data from excel to SQL Server Table

• kasaranenikiran-725528

  SSC Eights!

  Points: 818

  More actions

  January 28, 2011 at 6:46 am

  #157414

  Hi,

  I have an excel sheet with the Specific Backup Details.

  1.Server Name (Eg: Prod)

  2.Database name ( Eg:ABC)

  3.Backup Job (Eg: Prod Backup)

  4.Backup schedule ( eg: every day 6 AM)

  5.Enabled (Eg:Yes)

  6.Backup Size : (Eg: 10 MB)

  7.Last Backup : ( Eg:1/12/2010)

  8.Backup Method : (Eg: SQL Backup)

  I would like to create a table with the above mentioned columns and import this data from Excel to SQL Tables.

  Could you provide me what datattype to use ??

  I have about 25 server information on 25 sheets seperately in the excel file.

  And, I have the excel on my Desktop . I moved the file to server. But The server doesn't have the Excel software. So, I don't think I could use DTS (Import Export Wizard ) .

  WHat other options can be used to import this data from Excel file to SQL Table ?

  Thanks

  Kay

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737608

  More actions

  January 28, 2011 at 6:49 am

  #1279674

  If you run the import wizard from SSMS, it runs on your desktop, not the server. You can use that to import this into SQL Server.

• homebrew01

  SSC Guru

  Points: 55549

  More actions

  January 28, 2011 at 9:08 am

  #1279757

  The server doesn't need Excel to do the import. It uses the Excel driver included with SQL.

  How did the data get into Excel to start with ?

  Is this a one time process or part of a bigger project ?